Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9TOy-001SuI-0x for pgsql-hackers@arkaria.postgresql.org; Sun, 05 Apr 2026 19:44:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9TOw-004lbz-26 for pgsql-hackers@arkaria.postgresql.org; Sun, 05 Apr 2026 19:44:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9TOw-004lbr-0H for pgsql-hackers@lists.postgresql.org; Sun, 05 Apr 2026 19:44:54 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w9TOu-00000000jdc-2Do8 for pgsql-hackers@postgresql.org; Sun, 05 Apr 2026 19:44:53 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id CDADB1D000F5; Sun, 5 Apr 2026 15:44:50 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Sun, 05 Apr 2026 15:44:51 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm3; t=1775418290; x= 1775504690; bh=kDo89MF/UOYPTLwR3VwIE/HLkjPrGB2hpVDkFz/XGH0=; b=c M0/ZWp0XHcIV8q+VTPJIMs4fOsFfHo7QkoS+PhwdceVZFI0kK0OmqvhWwM+0n+hq jDePeCH/+T6A8cixN06EwXCb1CSELCKs1I7KITaD0FKX6BR8dFUC3U14sABQaHsS toJTZChk2NTX3swfKKPaYfJZJLNKN5wYSjX72obps28Hh+zO1D1fJ/wI3qKLMKQv R4NvJf8hV2GRQNb2SOd2VUJ7SMXa2fCXCXIVZxF5fipO2yEovWqz6FmTRy7OTzZF 9otOFl+oNFMYsLz2WpycLe2UF8oxJ16unoaB0tC1OZi2kzQK1taDrh+k6awEITfX DH4TfFWisg6E8UzD8AGCw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1775418290; x=1775504690; bh=k Do89MF/UOYPTLwR3VwIE/HLkjPrGB2hpVDkFz/XGH0=; b=Jc2gPZRsjM65uUR5W q0Iuq5dxLtmfHccLFJ0pr2MHze76NKa3f25wdhs+JEG2o021O1msBNsiQI3g/gC+ nCsZeuwAoqXemStig2/ptxXjZMedvEqzef2pCU7xObAcUyYqoSZZqMqnM7ekgJME +JJMWpEmOn4jy3kAlcUuaF1k0kYdVob9GbB/xuPwz1jq/gAI287bZIB72TaRQiTg S6r5ThsLtH4Nz/mOV+A3r78BvbF9cp+BwCzOH13M+okS949Lcz5Q37S1tGbojtyK T+LVByNc+mZUrjBm4UhtYrPel76t+9jT/tmmkt5WwunYhO0Waw88B+mVJ2vBxsSb xy19A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgdduheeihecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepteeuvdehffekvefgueehveetveekgfegtddtueefueehuddutdfhfeff hfejfeffnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohepiedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtoheprghnughrvghssegrnhgrrhgriigvlhdruggvpdhrtghpthhtohep phgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhgpdhrtghpthhtoheprgihuhhshhhtih ifrghrihdrshhlghdtudesghhmrghilhdrtghomhdprhgtphhtthhopegsohgvkhgvfihu rhhmodhpohhsthhgrhgvshesghhmrghilhdrtghomhdprhgtphhtthhopehsrgifrggurg drmhhshhhksehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghr shesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 5 Apr 2026 15:44:49 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1775418288; bh=cysUnmGkULLnaeOk/Y8TR5khIChL5WgLCqRcvMlWHUo=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=ZzoMoUIT7icd96xn9fdQnNngU1bSPCzW9DlZgG45ssOXTfPufZgH4P7PZ0iIwL5+Z o1N4BV7xX9fBigHlOhQcE84JOW0uTbgv7vLibHp9WXI4CJO9SVk6ubWlxYjLIRDCO2 0XIgT93ibsCe0ZfEWXEc29ewJFhFj9z10dKYIZa8ftX90JROl3wAF58RCn38vdwtub j6zgnO6RKip0JoHNHYa+zcVa4DewVndb6hpNSebzMfNtiWXKDRrVEm5zY7fkFeRjPt F0IVJVWZMnwBQLSbOxjHAVkcMjmw1esatmjx3zrMrUcSAs8COw0PXSfgbGRHJVTIq0 KYfGQCbxYP2KQ== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 727427C; Sun, 05 Apr 2026 21:44:48 +0200 (CEST) Date: Sun, 5 Apr 2026 21:44:48 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Andres Freund Cc: Ayush Tiwari , Matthias van de Meent , Peter Eisentraut , Masahiko Sawada , pgsql-hackers@postgresql.org Subject: Re: tid_blockno() and tid_offset() accessor functions Message-ID: <202604051942.hm4eg3s7fzcs@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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/