Re: pg 8.3 replication causing corruption

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Bob Hatfield <bobhatfield(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg 8.3 replication causing corruption
Date: 2011-10-13 12:49:49
Message-ID: CAHyXU0zeF109Av8HPMxZVCTTikuRLEg7hAP0v50MPeP=oA7SaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 12, 2011 at 5:17 PM, Bob Hatfield <bobhatfield(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vishnu S. 2011-10-13 12:55:09 Tablespace files deleted during continuous run
Previous Message Greg Sabino Mullane 2011-10-13 12:41:45 Re: link-spam (was Re: [GENERAL] 7)