Re: pg 8.3 replication causing corruption

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: pg 8.3 replication causing corruption
Дата
Msg-id CAHyXU0zeF109Av8HPMxZVCTTikuRLEg7hAP0v50MPeP=oA7SaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg 8.3 replication causing corruption  (Bob Hatfield <bobhatfield@gmail.com>)
Ответы Re: pg 8.3 replication causing corruption
Список 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 по дате отправления:

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: Bulk processing & deletion
Следующее
От: Alexander Pyhalov
Дата:
Сообщение: Re: Bulk processing & deletion