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

From Guillaume Lelarge
Subject Re: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Date
Msg-id CAECtzeW4WAdD3LGApAi5YH=Xq6GnyO54pWaFNG2tDpU=Cur92A@mail.gmail.com
Whole thread Raw
In response to Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Le ven. 14 déc. 2018 à 07:00, Ron <ronljohnsonjr@gmail.com> a écrit :
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.


It's an extension.


--
Guillaume.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Next
From: Michael Harris
Date:
Subject: Hot Standby Replica Recovery Problem