Re: [PERFORM] SELECT slows down on sixth execution

2015-10-19 Thread Thomas Kellerer
Jonathan Rogers schrieb am 17.10.2015 um 04:14: >>> Yes, I have been looking at both plans and can see where they diverge. >>> How could I go about figuring out why Postgres fails to see the large >>> difference in plan execution time? I use exactly the same parameters >>> every time I execute the

Re: [PERFORM] SELECT slows down on sixth execution

2015-10-19 Thread Merlin Moncure
On Fri, Oct 16, 2015 at 9:14 PM, Jonathan Rogers wrote: > On 10/16/2015 08:37 AM, Albe Laurenz wrote: >> Jonathan Rogers wrote: Look at the EXPLAIN ANALYZE output for both the custom plan (one of the first five executions) and the generic plan (the one used from the sixth time on) a