Re: Spreading full-page writes - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Spreading full-page writes
Date
Msg-id CAM-w4HMmQqhhctGu4URMgkEPh6zt178JCz3MVJVbJoGvuU=Ayg@mail.gmail.com
Whole thread Raw
In response to Re: Spreading full-page writes  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: Spreading full-page writes  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers

On Mon, May 26, 2014 at 1:22 PM, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
The second record is generated before the checkpoint is finished and the checkpoint record is written.  So it will be there.

(if you crash before the checkpoint is finished, the in-progress checkpoint is no good for recovery anyway, and won't be used)

Another idea would be to have separate checkpoints for each buffer partition. You would have to start recovery from the oldest checkpoint of any of the partitions.

--
greg

pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: SQL access to database attributes
Next
From: Alvaro Herrera
Date:
Subject: Re: Allowing line-continuation in pgbench custom scripts