Re: Multicolumn index corruption on 8.4 beta 2 - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Multicolumn index corruption on 8.4 beta 2
Date
Msg-id 4A2E5B080200002500027776@gw.wicourts.gov
Whole thread Raw
In response to Re: Multicolumn index corruption on 8.4 beta 2  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Multicolumn index corruption on 8.4 beta 2  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Yeah, AFAICT the writes are handed off to the operating system (just
> not synced), so if it flushes its caches sanely at all there
> shouldn't be a problem.
I would certainly *hope* that's the case.  We sometimes use fsync=off
for conversions, where we plan to just start over if the conversion
crashes, and set it to on when the conversion is done.  It would be
disturbing to discover that fsync=off also means "don't bother to
write dirty buffers to the OS before shutdown."
-Kevin


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7
Next
From: Jeff Davis
Date:
Subject: Re: [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7