Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Date
Msg-id CAMkU=1x0FStYSCEke5tu95qtjwvf7k_K53TAR90B3gb3LMNcZA@mail.gmail.com
Whole thread Raw
In response to Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Tue, May 6, 2014 at 7:18 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Simon Riggs <simon@2ndQuadrant.com> writes:
> Lets fix e_c_s at 25% of shared_buffers and remove the parameter
> completely, just as we do with so many other performance parameters.

Apparently, you don't even understand what this parameter is for.
Setting it smaller than shared_buffers is insane.

The e_c_s is assumed to be usable for each backend trying to run queries sensitive to it.  If you have dozens of such queries running simultaneously (not something I personally witness, but also not insane) and each of these queries has its own peculiar working set, then having e_c_s smaller than s_b makes sense.

I have a hard time believe that this is at all common, however.   Certainly not common enough so to justify cranking the setting all the way the other direction and then removing the crank handle.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: pgindent run for 9.4
Next
From: Tom Lane
Date:
Subject: Re: pg_shmem_allocations view