Request a Demo
Home   >   mailing lists

Re: Small optimization set tuple block/tableOid once - Mailing list pgsql-hackers

From David Rowley
Subject Re: Small optimization set tuple block/tableOid once
Date
Msg-id CAApHDvoAcEVUA9ybGRx2yQbz67pC9GUm1DsA6y0TpiSUzPd3mQ@mail.gmail.com
Whole thread Raw
In response to Re: Small optimization set tuple block/tableOid once  (Ranier Vilela <ranier.vf@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, 3 Apr 2025 at 23:09, Ranier Vilela <ranier.vf@gmail.com> wrote:
> rebased heapam.c and heapam_handler.c

This doesn't work. The tids are not being set in all cases.

patched:
select tableoid,ctid,oid from pg_class TABLESAMPLE BERNOULLI (100);
 tableoid |  ctid   |  oid
----------+---------+-------
     1259 | (0,0)   | 16409
     1259 | (0,0)   | 16403
     1259 | (0,0)   | 16412
     1259 | (0,0)   | 16407
     1259 | (0,0)   | 16415
     1259 | (0,0)   | 16418
     1259 | (0,0)   | 16434
...

master:
 tableoid |  ctid   |  oid
----------+---------+-------
     1259 | (0,10)  | 16409
     1259 | (0,11)  | 16403
     1259 | (0,12)  | 16412
     1259 | (0,13)  | 16407
     1259 | (0,15)  | 16415
     1259 | (0,16)  | 16418
     1259 | (0,17)  | 16434
...

David

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Correction of RowMark Removal During Sel-Join Elimination
Next
From: Chao Li
Date:
Subject: Re: Fix typo in code comment