[PERFORM] Recursive query performance issue

2015-10-20 Thread Jamie Koceniak
Version: --- PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit Query Plan http://explain.depesz.com/s/4s37 Normally, this query takes around 200-300 ms to execu

Re: [PERFORM] SELECT slows down on sixth execution

2015-10-20 Thread Pavel Stehule
2015-10-20 16:48 GMT+02:00 Jonathan Rogers : > On 10/20/2015 03:45 AM, Pavel Stehule wrote: > > > > > > 2015-10-20 8:55 GMT+02:00 Thomas Kellerer > >: > > > > Jonathan Rogers schrieb am 17.10.2015 um 04:14: > > >>> Yes, I have been looking at both plans and can

Re: [PERFORM] SELECT slows down on sixth execution

2015-10-20 Thread Jonathan Rogers
On 10/20/2015 03:45 AM, Pavel Stehule wrote: > > > 2015-10-20 8:55 GMT+02:00 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 abou

Re: [PERFORM] SELECT slows down on sixth execution

2015-10-20 Thread Pavel Stehule
2015-10-20 8:55 GMT+02:00 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 exac