Add pinning_backends column to the pg_buffercache extension.
Andres Freund <andres@anarazel.de>
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.
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pg_buffercache/Makefile | modified | +1 −1 |
| contrib/pg_buffercache/pg_buffercache--1.0--1.1.sql | added | +11 −0 |
| contrib/pg_buffercache/pg_buffercache--1.1.sql (from contrib/pg_buffercache/pg_buffercache--1.0.sql) | renamed | +3 −2 |
| contrib/pg_buffercache/pg_buffercache.control | modified | +1 −1 |
| contrib/pg_buffercache/pg_buffercache_pages.c | modified | +35 −2 |
| doc/src/sgml/pgbuffercache.sgml | modified | +7 −0 |