Re: old_snapshot_threshold bottleneck on replica - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: old_snapshot_threshold bottleneck on replica
Date
Msg-id CAH2-Wznj9qSNXZ1P1uWTUD_FeaTezbUazb416EPwi4Qr_jR_6A@mail.gmail.com
Whole thread Raw
In response to Re: old_snapshot_threshold bottleneck on replica  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: old_snapshot_threshold bottleneck on replica
List pgsql-hackers
On Tue, Sep 5, 2023 at 12:58 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> I hope we get "snapshot too old" back one day.

Thanks for working on this. Though I wonder why you didn't do
something closer to a straight revert of the feature. Why is nbtree
still passing around snapshots needlessly?

Also, why are there still many comments referencing the feature?
There's the one above should_attempt_truncation(), for example.
Another appears above init_toast_snapshot(). Are these just
oversights, or was it deliberate? You said something about retaining
vestiges.

--
Peter Geoghegan



pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: SQL:2011 application time
Next
From: Thomas Munro
Date:
Subject: Re: old_snapshot_threshold bottleneck on replica