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 1w16ix-002Z5x-1y for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 17:54:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w16iu-005guT-2A for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Mar 2026 17:54:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w16it-005guL-3A for pgsql-hackers@lists.postgresql.org; Fri, 13 Mar 2026 17:54:56 +0000 Received: from fhigh-b5-smtp.messagingengine.com ([202.12.124.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w16ir-000000000Q4-1YsL for pgsql-hackers@postgresql.org; Fri, 13 Mar 2026 17:54:56 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfhigh.stl.internal (Postfix) with ESMTP id 471DC7A01D7; Fri, 13 Mar 2026 13:54:49 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Fri, 13 Mar 2026 13:54:50 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1773424489; x=1773510889; bh=y32nz7mrTn 6a2BrqIgs4akAj0wGZXgDDA4VfNJUG7uA=; b=j0pHTqPQCo4cPNa+dBTLxKbKF9 MjgSJFvdbJUCpzSQHFNZYFWbo5yDYKxOZc5+J97YZXOC4feEtW3vGXQy74DECEXc gF75cRRk7ilMxL9rWdzhHGxt+w7bz7h6gkxEezVCLDxz8p2QKseV23l5P0Gh3puK r0C7G20cJEKslHwHatgz8nUbMdVYPcFBj13kEtDbhOPXYrbz5nHb82N2HvGCmtS6 DZUfqxL072T4lKL3Yg4Im6VSk5DcSx8dwgqeZL2fPkKy03HuTAK0SueGjfSXtP+T tCz7h6sbFS59TAp1+DpZziR6HVme2jxnbkMDge3SHybyZXJfQkj9pEse3dfw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1773424489; x=1773510889; bh=y32nz7mrTn6a2BrqIgs4akAj0wGZXgDDA4V fNJUG7uA=; b=s9eENe8vUuMP3+7mjZF1RYw9NJnznUTu/9U6v2AXBHwStUNXcUM v0MmC7eM3nxxkuR25MtcDdXkNSKwMKGYYyoTIsG2zFq+rv9A0PFlvO7Aj9bx4BAn ncVKMmFMur3wKuQ510JKcDKWPQxFU6zLqy+HHeOE98s/hInFdx2l2hXcjgyehT7+ B9tpaFqrRXk5se3OmJ3Cf3o+luxz7vjTO9smmIMICx+5gYVon5XFc0KfqaqGOIpf QWDsZs5kWUQHQUQItC97gK6bgP2pDgTI9WhQZuQDioTbZXqS9KuaRUyrVfeOm/g/ oPVyYTzscUwREFPzW9V9NzOW+95M8eswaPQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgddvledtfeduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkfhggtggujgesthdtsfdttddtvdenucfhrhhomheptehnughrvghs ucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrfgrth htvghrnhepfeffgfelvdffgedtveelgfdtgefghfdvkefggeetieevjeekteduleevjefh ueegnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprg hnughrvghssegrnhgrrhgriigvlhdruggvpdhnsggprhgtphhtthhopeehpdhmohguvgep shhmthhpohhuthdprhgtphhtthhopehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgh dprhgtphhtthhopegrhihushhhthhifigrrhhirdhslhhgtddusehgmhgrihhlrdgtohhm pdhrtghpthhtohepsghovghkvgifuhhrmhdophhoshhtghhrvghssehgmhgrihhlrdgtoh hmpdhrtghpthhtohepshgrfigruggrrdhmshhhkhesghhmrghilhdrtghomhdprhgtphht thhopehpghhsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 13 Mar 2026 13:54:48 -0400 (EDT) Date: Fri, 13 Mar 2026 13:54:48 -0400 From: Andres Freund To: Matthias van de Meent Cc: Peter Eisentraut , Masahiko Sawada , Ayush Tiwari , pgsql-hackers@postgresql.org Subject: Re: tid_blockno() and tid_offset() accessor functions Message-ID: References: <8a2e78c3-2f63-455f-80a9-cbd9eebaa245@eisentraut.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2026-03-13 18:08:04 +0100, Matthias van de Meent wrote: > As for naming; I'd personally prefer to have 'heap' included in the > names here (e.g. heaptid_blkno(tid) or heap_blkno[_of](tid)), because > not all AMs may map tid.blkno exactly to a block number in the main > fork. While PostgreSQL (in core) currently only knows about the heap > AM, we should probably keep clear of pretending that all tableAMs > produce TIDs that behave exactly like heap's do. Meh. As long as tids themselves are split like they are, without any variability of the amount of space dedicated for either component, I don't see any advantage in that. Greetings, Andres Freund