Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Date: 2018-12-14 06:00:09
Message-ID: 49ee13f3-036d-06fb-5382-8b38bc2c6a19@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2018-12-14 07:04:56 Re: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Previous Message Thomas Munro 2018-12-14 04:51:09 Re: shared_buffers on Big RAM systems