Re: [PERFORM] Recursive query performance issue

2015-10-21 21:32 GMT+02:00 Jamie Koceniak : > adama_prod=# SHOW shared_buffers; > > shared_buffers > > > > 64GB > can you try to increase shared buffers to 200GB and decrease effective cache size to 180GB? If it is possibly - I am not sure, if this

Re: [PERFORM] Recursive query performance issue

2015-10-21 20:51 GMT+02:00 Jamie Koceniak : > Hi Pavel, > > > > Or were you referring to SHMMAX? > value of shared_buffers - run SQL statements SHOW shared_buffers; Regards Pavel > > > Thanks > > > > *From:* Jamie Koceniak > *Sent:* Wednesday, October 21, 2015 11:40

Re: [PERFORM] Recursive query performance issue

On Wed, Oct 21, 2015 at 2:45 PM, Pavel Stehule wrote: > 2015-10-21 21:32 GMT+02:00 Jamie Koceniak : >> >> adama_prod=# SHOW shared_buffers; >> >> shared_buffers >> >> >> >> 64GB > > > can you try to increase shared buffers to

Re: [PERFORM] Recursive query performance issue

2015-10-21 19:55 GMT+02:00 Jamie Koceniak : > Hi Pavel, > > > > Thanks for the reply. > > > > 1. The queries aren’t waiting on any locks. > > The query has a recursive join that uses a table with only 80k records and > that table is not updated often. > > > > 2. The I/O

Re: [PERFORM] Recursive query performance issue

On Tue, Oct 20, 2015 at 12:34 PM, Jamie Koceniak wrote: > Version: > > --- > > PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Debian > 4.7.2-5) 4.7.2, 64-bit > >

Re: [PERFORM] Recursive query performance issue

Hi 2015-10-20 19:34 GMT+02:00 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 > > > >