Re: Recursive query performance issue - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Recursive query performance issue
Date
Msg-id CAHyXU0ySTF-9GueWvFma6LQzMdR=M4VXf+FzwcT2XXRYo7cxxw@mail.gmail.com
Whole thread Raw
In response to Re: Recursive query performance issue  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Recursive query performance issue
List pgsql-performance
On Wed, Oct 21, 2015 at 2:45 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2015-10-21 21:32 GMT+02:00 Jamie Koceniak <jkoceniak@mediamath.com>:
>>
>> 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 setting is good
> fro production usage, but the result can be interesting for bottleneck
> identification.

we need to see a snapshot from
*) top
*) perf top

merlin


pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Recursive query performance issue
Next
From: vincent elschot
Date:
Subject: Re: Recursive query performance issue