On Sat, Apr 10, 2010 at 4:47 PM, Ben Chobot <be...@silentmedia.com> wrote: > My understanding is that this generally happens because the plan should be > different for the different values, but the first time the function is run it > caches the plan for one of the values and will never use the appropriate plan > for the second value.
No, it plans based on a sort of "generic value", not the first one you supply. The way to get at that plan is: PREPARE foo AS <query>; EXPLAIN EXECUTE foo (parameters); ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
