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
On Wed, Apr 16, 2008 at 11:09 AM, Tom Lane <
tgl@sss.pgh.pa.us> wrote:
"Gavin M. Roy" <
gmr@myyearbook.com> writes:
> In 8.3.0, I'm seeing some oddities with SQL functions which I thought were
> immune to the planner data restrictions of plpgsql functions and the sort.
in general SQL functions face the same hazards of bad parameterized
plans as plpgsql functions do.
regards, tom lane