2015-10-17 15:29 GMT+02:00 Yves Dorfsman <y...@zioup.com>: > On 2015-10-14 03:00, Albe Laurenz wrote: > > > > You are encountering "custom plans", introduced in 9.2. > > > > When a statement with parameters is executed, PostgreSQL will not only > generate > > a generic plan, but for the first 5 executions it will substitute the > arguments > > and generate and execute a custom plan for that. > > Wow! Thanks. I feel this should be documented a bit better. > > Shouldn't this be explained in at least as much details as in your > explanation, in the sql-prepare document? >
probably - some section about benefits and risks can be useful - but it is task for somebody with better English than is mine :) Regards Pavel > > Yves. > -- > http://yves.zioup.com > gpg: 4096R/32B0F416 > > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
