Thread: pg_buffercache

Hi all,

I was wondering if it is safe to install pg_buffercache on production systems?

Thank you.

On Tue, Oct 30, 2012 at 1:34 PM, pg noob <pgnube@gmail.com> wrote:
>
> Hi all,
>
> I was wondering if it is safe to install pg_buffercache on production
> systems?

Well, why wouldn't you expect it to be safe?  Core extensions should
be mostly assumed safe unless there is a good reasons to believe
otherwise.  That said, there may be some performance impacts,  In
particular, take note:

"When the pg_buffercache view is accessed, internal buffer manager
locks are taken for long enough to copy all the buffer state data that
the view will display. This ensures that the view produces a
consistent set of results, while not blocking normal buffer activity
longer than necessary. Nonetheless there could be some impact on
database performance if this view is read often."

merlin