Re: Make TID Scans recalculate the TIDs less often - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Make TID Scans recalculate the TIDs less often
Date
Msg-id 10FD69B7-B572-42CD-A571-FD502E74FA1A@yandex-team.ru
Whole thread Raw
In response to Make TID Scans recalculate the TIDs less often  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Make TID Scans recalculate the TIDs less often
List pgsql-hackers

> On 17 Sep 2025, at 09:59, David Rowley <dgrowleyml@gmail.com> wrote:
>
> Does anyone think this is worth pursuing further?

I heard of following use-case: data transferring system partition big tables by ctid ranges to mimic parallel secscan,
butwith many network connections. Some performance improvement was claimed and connection failure resistance (when one
connectionwas broken only one partition is rescanned with same snapshot). 

I'm not entirely sure this is a safe approach (I have a gut feeling that tid scan is not MVCC safe). But for retrieving
verybig tables without strong guarantees this might make some sense. 

Would your patch improve performance of such case?


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Konstantin Knizhnik
Date:
Subject: Re: Parallel Apply
Next
From: Shubham Khanna
Date:
Subject: Re: Add support for specifying tables in pg_createsubscriber.