Thanks everyone for your response. I will try these settings.
On Tue, Jun 2, 2015 at 1:28 PM, Graeme B. Bell <grb@xxxxxxxxxxxxxxxxx> wrote:
> I believe yes / 0 are the default settings for synchronous commit and commit_delay. ** (Interestingly the manual pages do not specify.) **
Sorry, I've just spotted the settings in the text. The statement (marked **) is incorrect.
Defaults are yes/0. (http://www.postgresql.org/docs/9.4/static/runtime-config-wal.html)
Graeme.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance