> 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,
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2010-03-26 14:00:38|
|Subject: Re: Why Wal_buffer is 64KB|
|Previous:||From: Richard Huxton||Date: 2010-03-26 12:18:25|
|Subject: Re: Performance Tuning Large PL/PGSQL Stored Procedure|