Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Date
Msg-id 17469.1399385919@sss.pgh.pa.us
Whole thread Raw
In response to Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Simon Riggs <simon@2ndQuadrant.com>)
Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Tree view 
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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: New pg_lsn type doesn't have hash/btree opclasses
Next
From: Simon Riggs
Date:
Subject: Re: sb_alloc: a new memory allocator for PostgreSQL