Re: Multicolumn index corruption on 8.4 beta 2

From: Floris Bos / Maxnet <bos(at)je-eigen-domein(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multicolumn index corruption on 8.4 beta 2
Date: 2009-06-09 16:29:09
Message-ID: 4A2E8DD5.4050004@je-eigen-domein.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Simon Riggs wrote:
> On Tue, 2009-06-09 at 13:40 +0200, Floris Bos / Maxnet wrote:
>> fsync = off
>
> That's a bad plan if you care about your database.

I am aware of the risk of dataloss in case of power failure, etc.

However fsync=on is simply too slow for my purpose, and it concerns data
that can be regenerated from its source.

The website this setup is for has been running various previous versions
of PostgreSQL with fsync=off since 2005.
So I still expect it to work.

Yours sincerely,

Floris Bos

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-06-09 16:31:11 Not quite a security hole in internal_in
Previous Message Florian Weimer 2009-06-09 16:12:01 Re: Multicolumn index corruption on 8.4 beta 2