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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)
Date: 2018-12-14 07:04:56
Message-ID: CAECtzeW4WAdD3LGApAi5YH=Xq6GnyO54pWaFNG2tDpU=Cur92A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le ven. 14 déc. 2018 à 07:00, Ron <ronljohnsonjr(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Harris 2018-12-14 07:40:20 Hot Standby Replica Recovery Problem
Previous Message Ron 2018-12-14 06:00:09 Installing pg_buffercache (was Re: shared_buffers on Big RAM systems)