Re: Why Wal_buffer is 64KB - Mailing list pgsql-performance

From Pierre C
Subject Re: Why Wal_buffer is 64KB
Date
Msg-id op.u96ge7lfeorkce@localhost
Whole thread Raw
In response to Re: Why Wal_buffer is 64KB  (Tadipathri Raghu <traghu.dba@gmail.com>)
Responses Re: Why Wal_buffer is 64KB
List 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).

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Performance Tuning Large PL/PGSQL Stored Procedure
Next
From: Scott Marlowe
Date:
Subject: Re: Why Wal_buffer is 64KB