agora inbox for pgsql-committers@postgresql.org  
help / color / mirror / Atom feed
From: Heikki Linnakangas <heikki.linnakangas@iki.fi>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Modernize and optimize pg_buffercache_pages()
Date: Tue, 07 Apr 2026 13:06:42 +0000
Message-ID: <E1wA68f-003Ofv-3B@gemulon.postgresql.org> (raw)

Modernize and optimize pg_buffercache_pages()

Refactor pg_buffercache_pages() to use SFRM_Materialize mode and
construct a tuplestore directly. That's simpler and more efficient
than collecting all the data to a custom array first.

Author: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Author: Palak Chaturvedi <chaturvedipalak1911@gmail.com>
Discussion: https://www.postgresql.org/message-id/CAExHW5sMsaz1j+hrdhyo-DJp7JCgJx87=q2iJfOc_9mwYWyvmw@mail.gmail...

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/257c8231bf97a77378f6fedb826b1243f0a41612

Modified Files
--------------
contrib/pg_buffercache/pg_buffercache_pages.c | 244 ++++++++------------------
1 file changed, 77 insertions(+), 167 deletions(-)



Message-ID: <E1wA68f-003Ofv-3B@gemulon.postgresql.org>
Permalink:  ../E1wA68f-003Ofv-3B@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1wA68f-003Ofv-3B@gemulon.postgresql.org

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: heikki.linnakangas@iki.fi, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Modernize and optimize pg_buffercache_pages()
  In-Reply-To: <E1wA68f-003Ofv-3B@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox