Horton

Re: tid_blockno() and tid_offset() accessor functions

Álvaro Herrera <alvherre@kurilemu.de>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@kurilemu.de>
To: Andres Freund <andres@anarazel.de>
Cc: Ayush Tiwari <ayushtiwari.slg01@gmail.com>, Matthias van de Meent <boekewurm+postgres@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, Masahiko Sawada <sawada.mshk@gmail.com>, pgsql-hackers@postgresql.org
Date: 2026-04-05T19:44:48Z
Lists: pgsql-hackers 
Hello

On 2026-Apr-05, Andres Freund wrote:

> I was reminded of this thread while in the process of doing some performance
> validation that required getting all the block numbers from an index scan,
> which required me to remember (ctid::text::point)[0], which I find to be very
> ugly.

Thanks for this patch!  I agree that the statu quo was sort of embarrasing :-)

Regards

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/

Commits

  1. Add tid_block() and tid_offset() accessor functions