Re: COMMIT NOWAIT Performance Option - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: COMMIT NOWAIT Performance Option
Date
Msg-id 200702281935.l1SJZ9625120@momjian.us
Whole thread Raw
In response to COMMIT NOWAIT Performance Option  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: COMMIT NOWAIT Performance Option  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
Jonah H. Harris wrote:
> On 2/28/07, Bruce Momjian <bruce@momjian.us> wrote:
> > Am am not comfortable starting and having something fail later.
> 
> Then do you have some other idea for protecting pages from being torn
> without storing an entire backup copy or performing a block-level
> consistency check?

We have several methods suggested to check the blocks, like CRC.  My
point was that, whatever check method we use, we should be prepared to
check on startup, or at least make it the default for a crash restart.

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: SOC & user quotas
Next
From: "Jonah H. Harris"
Date:
Subject: Re: COMMIT NOWAIT Performance Option