pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: pg_buffercache: Change page_num type to bigint
Date: Tue, 08 Apr 2025 10:42:38 +0000
Message-ID: <E1u26Pe-003HPz-2G@gemulon.postgresql.org> (raw)

pg_buffercache: Change page_num type to bigint

The page_num was defined as integer, which should be sufficient for the
near future (with 4K pages it's 8TB). But it's virtually free to return
bigint, and get a wider range. This was agreed on the thread, but I
forgot to tweak this in ba2a3c2302f1.

While at it, make the data types in CREATE VIEW a bit more consistent.

Discussion: https://postgr.es/m/CAKZiRmxh6KWo0aqRqvmcoaX2jUxZYb4kGp3N%3Dq1w%2BDiH-696Xw%40mail.gmail.co

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/91f1fe90c7d42641201bd2c474bd86d703b5e830

Modified Files
--------------
contrib/pg_buffercache/pg_buffercache--1.5--1.6.sql | 2 +-
contrib/pg_buffercache/pg_buffercache_pages.c       | 6 +++---
doc/src/sgml/pgbuffercache.sgml                     | 2 +-
3 files changed, 5 insertions(+), 5 deletions(-)



Message-ID: <E1u26Pe-003HPz-2G@gemulon.postgresql.org>
Permalink:  ../E1u26Pe-003HPz-2G@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1u26Pe-003HPz-2G@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: tomas.vondra@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: pg_buffercache: Change page_num type to bigint
  In-Reply-To: <E1u26Pe-003HPz-2G@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox