Re: Small optimization set tuple block/tableOid once

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Small optimization set tuple block/tableOid once
Дата
Msg-id CAApHDvoAcEVUA9ybGRx2yQbz67pC9GUm1DsA6y0TpiSUzPd3mQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Small optimization set tuple block/tableOid once  (Ranier Vilela <ranier.vf@gmail.com>)
Список pgsql-hackers
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 по дате отправления: