On Tue, Oct 30, 2012 at 1:34 PM, pg noob <pgnube@xxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
