Re: COMMIT NOWAIT Performance Option

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Jeff Davis" <pgsql(at)j-davis(dot)com>
Cc: "Bruce Momjian" <bruce(at)momjian(dot)us>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: COMMIT NOWAIT Performance Option
Date: 2007-02-28 20:37:11
Message-ID: 36e682920702281237g287c564ck59f8f825998e01c3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/28/07, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
> I'm not saying there's no cost, but the extra recovery cost seems lower
> to me than the CRC cost on every data page read during operation.

I agree, I just think it should be configurable.

> Also, if we find an error, do we even have the ability to correct it? A
> CRC doesn't tell us which pages were written and which weren't, so we
> could detect the error but not correct it, right?

Correct.

--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2007-02-28 20:39:18 Re: COMMIT NOWAIT Performance Option
Previous Message Jeff Davis 2007-02-28 20:17:02 Re: COMMIT NOWAIT Performance Option