On Sat, Apr 10, 2010 at 4:47 PM, Ben Chobot <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
