Re: Restartable Recovery - Mailing list pgsql-patches

From Tom Lane
Subject Re: Restartable Recovery
Date
Msg-id 29986.1153061507@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restartable Recovery  (Andreas Seltenreich <andreas+pg@gate450.dyndns.org>)
Responses Re: Restartable Recovery
List pgsql-patches
Andreas Seltenreich <andreas+pg@gate450.dyndns.org> writes:
> Simon Riggs <simon@2ndquadrant.com> writes:
>> [2. text/x-patch; restartableRecovery.patch]

> Hmm, wouldn't you have to reboot the resource managers at each
> checkpoint? I'm afraid otherwise things like postponed page splits
> could get lost on restart from a later checkpoint.

Ouch.  That's a bit nasty.  You can't just apply a postponed split at
checkpoint time, because the WAL record could easily be somewhere after
the checkpoint, leading to duplicate insertions.  Right offhand I don't
see how to make this work :-(

            regards, tom lane

pgsql-patches by date:

Previous
From: David Fetter
Date:
Subject: Re: Have psql display names and OUT/INOUT in \df output
Next
From: Simon Riggs
Date:
Subject: Re: Restartable Recovery