Re: Maximize page freezing

2022-07-29 Thread Matthias van de Meent
On Fri, 29 Jul 2022 at 16:38, Simon Riggs wrote: > > On Thu, 28 Jul 2022 at 14:55, Matthias van de Meent > wrote: > > Great idea, yet this patch seems to only freeze those tuples that are > > located after the first to-be-frozen tuple. It should probably > > re-visit earlier live tuples to potent

Re: Maximize page freezing

2022-07-29 Thread Peter Geoghegan
On Fri, Jul 29, 2022 at 5:55 AM Simon Riggs wrote: > > I should be able to post something in a couple of weeks. > > How do you see that affecting this thread? Well, it's clearly duplicative, at least in part. That in itself doesn't mean much, but there are some general questions (that apply to an

Re: Maximize page freezing

2022-07-29 Thread Simon Riggs
On Thu, 28 Jul 2022 at 14:55, Matthias van de Meent wrote: > > On Thu, 28 Jul 2022 at 15:36, Simon Riggs > wrote: > > > > Starting new thread with updated patch to avoid confusion, as > > mentioned by David Steele on the original thread: > > Original messageid: 20201118020418.GA13408@alvherre.pg

Re: Maximize page freezing

2022-07-29 Thread Simon Riggs
On Thu, 28 Jul 2022 at 20:57, Peter Geoghegan wrote: > > On Thu, Jul 28, 2022 at 6:56 AM Matthias van de Meent > wrote: > > Great idea, yet this patch seems to only freeze those tuples that are > > located after the first to-be-frozen tuple. It should probably > > re-visit earlier live tuples to

Re: Maximize page freezing

2022-07-28 Thread Peter Geoghegan
On Thu, Jul 28, 2022 at 6:56 AM Matthias van de Meent wrote: > Great idea, yet this patch seems to only freeze those tuples that are > located after the first to-be-frozen tuple. It should probably > re-visit earlier live tuples to potentially freeze those as well. I have a big patch set pending

Re: Maximize page freezing

2022-07-28 Thread Matthias van de Meent
On Thu, 28 Jul 2022 at 15:36, Simon Riggs wrote: > > Starting new thread with updated patch to avoid confusion, as > mentioned by David Steele on the original thread: > Original messageid: 20201118020418.GA13408@alvherre.pgsql > On Wed, 18 Nov 2020 at 02:04, Alvaro Herrera wrote: > > On 2020-Nov-

Maximize page freezing

2022-07-28 Thread Simon Riggs
Starting new thread with updated patch to avoid confusion, as mentioned by David Steele on the original thread: Original messageid: 20201118020418.GA13408@alvherre.pgsql On Wed, 18 Nov 2020 at 02:04, Alvaro Herrera wrote: > On 2020-Nov-17, Simon Riggs wrote: > > > As an additional optimization, if