Quantcast

pg_buffercache

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

pg_buffercache

pg noob

Hi all,

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

Thank you.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: pg_buffercache

Merlin Moncure-2
On Tue, Oct 30, 2012 at 1:34 PM, pg noob <[hidden email]> 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


--
Sent via pgsql-performance mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Loading...