"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> So, what's the real burden like from the pg_buffercache contrib module?
I wonder whether pg_buffercache should be changed to work like the
statistics views do, ie, you take a snapshot during the first call
within a transaction. This would allow correl
On Feb 9, 2008 10:34 PM, Markus Bertheau <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I want to use the pg_buffercache contrib module for monitoring our
> server. It takes a lock on all buffers and then on each buffer header
> in order to get a consistent picture of the buffers. I would be
> running the fu
"Markus Bertheau" <[EMAIL PROTECTED]> writes:
> Does removing all locking as in the attached patch have any negative
> impact other than the non-consistency of the results?
Removing the LockBufHdr bit is definitely a pretty foolish idea.
regards, tom lane