Re: pg 8.3 replication causing corruption - Mailing list pgsql-general

From Merlin Moncure
Subject Re: pg 8.3 replication causing corruption
Date
Msg-id CAHyXU0zeF109Av8HPMxZVCTTikuRLEg7hAP0v50MPeP=oA7SaQ@mail.gmail.com
Whole thread Raw
In response to Re: pg 8.3 replication causing corruption  (Bob Hatfield <bobhatfield@gmail.com>)
Responses Re: pg 8.3 replication causing corruption
List pgsql-general
On Wed, Oct 12, 2011 at 5:17 PM, Bob Hatfield <bobhatfield@gmail.com> wrote:
>> Something about your setup is suspect. Disks perhaps.
>
> Disk: Fusion IOdrive (1.2TB NAND drive)
>
> I've read that one should set wal_sync_method=fsync_writethrough for
> Windows servers.  It's currently set to open_datasync, I have no idea
> what effect that will have other than I've read less performance.
>
> Thoughts?

have you had any power events?  hard shutdowns, etc? I wonder if the
problem is in the clog files, and not the heap itself.

merlin

pgsql-general by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Bulk processing & deletion
Next
From: Alexander Pyhalov
Date:
Subject: Re: Bulk processing & deletion