Postgres Pro
Downloads
Home   >   mailing lists

Re: xlog checkpoint depends on sync() ... seems unsafe - Mailing list pgsql-hackers

From Tom Lane
Subject Re: xlog checkpoint depends on sync() ... seems unsafe
Date
Msg-id 18005.984458933@sss.pgh.pa.us
Whole thread Raw
In response to RE: xlog checkpoint depends on sync() ... seems unsafe  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
Tree view 
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> Maybe now, with two checkpoints in log, we should start redo from
> oldest one? This will increase recovery time of course -:(

Yeah, and it doesn't even solve the problem: consider a crash just
after we've written a shutdown checkpoint record.  On restart,
we won't think we need to redo anything at all.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: xlog checkpoint depends on sync() ... seems unsafe
Next
From: "Dominic J. Eidson"
Date:
Subject: Re: RE: xlog checkpoint depends on sync() ... seems unsafe