Re: Why Wal_buffer is 64KB

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Tadipathri Raghu" <traghu(dot)dba(at)gmail(dot)com>
Cc: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Why Wal_buffer is 64KB
Date: 2010-03-26 13:43:45
Message-ID: op.u96ge7lfeorkce@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> After fsync/syncronous_commit off

Do not use fsync off, it is not safe. Who cares about the performance of
fsync=off, when in practice you'd never use it with real data.
synchronnous_commit=off is fine for some applications, though.

More info is needed about your configuration (hardware, drives, memory,
etc).

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-03-26 14:00:38 Re: Why Wal_buffer is 64KB
Previous Message Richard Huxton 2010-03-26 12:18:25 Re: Performance Tuning Large PL/PGSQL Stored Procedure