Add pinning_backends column to the pg_buffercache extension.
authorAndres Freund <andres@anarazel.de>
Thu, 21 Aug 2014 22:28:37 +0000 (00:28 +0200)
committerAndres Freund <andres@anarazel.de>
Thu, 21 Aug 2014 22:28:37 +0000 (00:28 +0200)
commitf57791985ac3d776cb67e9d69befde538cfdf13b
tree334e1096d00e11c63c69c676e878a968883e6db7
parentce486056ecd28050f367894a2b5aad3656d37511
Add pinning_backends column to the pg_buffercache extension.

The new column shows how many backends have a buffer pinned. That can
be useful during development or to diagnose production issues
e.g. caused by vacuum waiting for cleanup locks.

To handle upgrades transparently - the extension might be used in
views - deal with callers expecting the old number of columns.

Reviewed by Fujii Masao and Rajeev rastogi.
contrib/pg_buffercache/Makefile
contrib/pg_buffercache/pg_buffercache--1.0--1.1.sql [new file with mode: 0644]
contrib/pg_buffercache/pg_buffercache--1.1.sql [moved from contrib/pg_buffercache/pg_buffercache--1.0.sql with 88% similarity]
contrib/pg_buffercache/pg_buffercache.control
contrib/pg_buffercache/pg_buffercache_pages.c
doc/src/sgml/pgbuffercache.sgml