On 13/01/16 14:36, Vladimir Sitnikov wrote:
Say you already have a plan which looks like this:
Now the plan gets invoked with $1 = 5. What exactly in your mind would happen
here?
A sequential scan with $1=5 condition. What else could be there?
I don't know, it's your proposal :-) But it looks like I misunderstood.
Note: I do not suggest changing already cached plans yet.
I suggest looking into "6th bind values" when building a cached plan.
But that wouldn't have helped your case. The custom plan is *more
expensive*; I'm guessing because the generic plan gambles on a better
average case instead of preparing for the worst case.
.m
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers