Re: SQL Function Slowness, 8.3.0

by jd@[EMAIL PROTECTED] ("Joshua D. Drake") Apr 16, 2008 at 11:58 AM

On Wed, 16 Apr 2008 14:44:40 -0400
"Gavin M. Roy" <gmr@[EMAIL PROTECTED]
> wrote:

> After detailed examination of pg_stat_user_indexes usage, it's clear
> that the functions don't use the same indexes.  I've casted
> everything to match the indexes in the SQL function, to no success.
> Any suggestions on next steps?  Maybe for 8.4 we could find a way to
> explain analyze function internals ;-)
> Gavin

To quote Tom in the appropriate bottom posting method:

> >
> > Without a specific example this discussion is pretty content-free,
> > but in general SQL functions face the same hazards of bad
> > parameterized plans as plpgsql functions do.
> >
> >                        regards, tom lane
> >

Sincerely,

Joshua D. Drake


-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/

PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance