Re: collateral benefits of a crash-safe visibility map - Mailing list pgsql-hackers

From Robert Haas
Subject Re: collateral benefits of a crash-safe visibility map
Date
Msg-id BANLkTi=1b3Cw_GREU1ROau39BO-3nWC7+w@mail.gmail.com
Whole thread Raw
In response to Re: collateral benefits of a crash-safe visibility map  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: collateral benefits of a crash-safe visibility map  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: collateral benefits of a crash-safe visibility map  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Tue, May 10, 2011 at 12:57 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> Hmmm, do we really need to WAL log freezing?
>
> Can we break down freezing into a 2 stage process, so that we can have
> first stage as a lossy operation and a second stage that is WAL
> logged?

That might solve the relfrozenxid problem - set the bits in the heap,
sync the heap, then update relfrozenxid once the heap is guaranteed
safely on disk - but it again seems problematic for Hot Standby.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: crash-safe visibility map, take five
Next
From: Robert Haas
Date:
Subject: Re: crash-safe visibility map, take five