Re: Summary function for pg_buffercache

Melih Mutlu <m.melihmutlu@gmail.com>

From: Melih Mutlu <m.melihmutlu@gmail.com>

To: Zhang Mingli <zmlpostgres@gmail.com>

Cc: Andres Freund <andres@anarazel.de>, Aleksander Alekseev <aleksander@timescale.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2022-09-28T15:19:57Z

Lists: pgsql-hackers

Attachments

v14-0001-Added-pg_buffercache_summary-function.patch (application/octet-stream) patch v14-0001

Hi,

Seems like the commit a448e49bcbe40fb72e1ed85af910dd216d45bad8 reverts the
changes on pg_buffercache.

Why compute usagecount_avg twice?
>
Then, I'm going back to v11 + the fix for this.

Thanks,
Melih

Commits

pg_buffercache: Add pg_buffercache_summary()
- 2589434ae0fb 16.0 landed
Revert 56-bit relfilenode change and follow-up commits.
- a448e49bcbe4 16.0 cited