On Wed, 16 Apr 2008 14:44:40 -0400
"Gavin M. Roy" <gmr@myyearbook.com> 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