Installing pg_buffercache (was Re: shared_buffers on Big RAM systems) - Mailing list pgsql-general

From Ron
Subject Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Date
Msg-id 49ee13f3-036d-06fb-5382-8b38bc2c6a19@gmail.com
Whole thread Raw
In response to Re: shared_buffers on Big RAM systems  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Responses Re: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
On 12/13/2018 08:25 PM, Rene Romero Benavides wrote:
> This topic seems to be always open to discussion. In my opinion, it 
> depends on how big your work dataset is, there's no use in sizing 
> shared_buffers beyond that size. I think, the most reasonable thing is 
> analyzing each case as proposed here:
> https://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/

https://www.postgresql.org/docs/current/pgbuffercache.html

Is this an extension or a shared preload library?  The documentation doesn't 
specify.

Thanks

-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: shared_buffers on Big RAM systems
Next
From: Guillaume Lelarge
Date:
Subject: Re: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)