On Wed, 16 Apr 2008 14:44:40 -0400 "Gavin M. Roy" <[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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
