|From:||Andres Freund <andres(at)2ndquadrant(dot)com>|
|Subject:||Add the number of pinning backends to pg_buffercache's output|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
The last week I twice had the need to see how many backends had some
buffers pinned. Once during development and once while analyzing a stuck
vacuum (waiting for a cleanup lock).
I'd like to add a column to pg_buffercache exposing that. The name I've
come up with is 'pinning_backends' to reflect the fact that it's not the
actual pincount due to the backend private arrays.
I'll add this patch to to 2014-06 CF.
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
|Next Message||Jan Wieck||2014-04-12 12:34:49||Re: Problem with txid_snapshot_in/out() functionality|
|Previous Message||MauMau||2014-04-12 07:51:25||Re: [bug fix] pg_ctl always uses the same event source|