Re: Multicolumn index corruption on 8.4 beta 2

Floris,

> 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.

You've been lucky, that's all.

Our documentation has been clear, back to version 7.0, that turning
fsync=off carries the risk that you will have to recreate your entire
database in the event of unexpected shutdown. That's not new.

So, the operative question is: was 8.4 shut down with -immediate or
otherwise unexpectedly? If so, then we don't have a bug. If 8.4 was
never shut down, then we have some strange behavior which bears looking
into. And you've found a wierd corner case, which is what we count on
our users for.

Thanks for testing.

--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com