From: | Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: heapam: Only set tuple's block once per page in pagemode |
Date: | 2025-04-01 10:33:56 |
Message-ID: | E1tzYwO-0025yW-15@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
heapam: Only set tuple's block once per page in pagemode
Due to splitting the block id into two 16 bit integers, BlockIdSet()
is more expensive than one might think. Doing it once per returned
tuple shows up as a small but reliably reproducible cost. It's simple
enough to set the block number just once per block in pagemode, so do
so.
Author: Andres Freund <andres(at)anarazel(dot)de>
Discussion: https://www.postgresql.org/message-id/lxzj26ga6ippdeunz6kuncectr5gfuugmm2ry22qu6hcx6oid6@lzx3sjsqhmt6
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/2904324a88f672b2ecc22735279c16d6e1ee178c
Modified Files
--------------
src/backend/access/heap/heapam.c | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2025-04-01 13:03:25 | Re: pgsql: Add support for OAUTHBEARER SASL mechanism |
Previous Message | John Naylor | 2025-04-01 06:48:07 | Re: pgsql: Inline CRC computation for small fixed-length input on x86 |