Groups > comp.databases.postgresql > #119

Re: synchronous_commit on Wiki

From	Thomas Guettler <hv@tbz-pariv.de>
Newsgroups	comp.databases.postgresql
Subject	Re: synchronous_commit on Wiki
Date	2011-05-11 08:53 +0200
Message-ID	<92uq3pFnajU1@mid.individual.net> (permalink)
References	<927ub6F3drU1@mid.individual.net> <1304411410.99095@proxy.dienste.wien.at>

Show all headers | View raw

On 03.05.2011 10:29, Laurenz Albe wrote:
> Thomas Guettler wrote:
>> on http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
>>
>> {{{
>> For situations where a small amount of data loss is acceptable in return for a large boost in how many updates you can
>> do to the database per second, consider switching to synchronous commit
>> }}}
>>
>> I am not a native english speaker, but I think this is wrong. I guess it should
>> be "... consider switching synchronous commit off".
> 
> You are right.
> 
> See http://www.postgresql.org/docs/current/static/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT

OK, I updated the wiki.

  Thomas Güttler

-- 
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

synchronous_commit on Wiki Thomas Guettler <hv@tbz-pariv.de> - 2011-05-02 16:44 +0200
  Re: synchronous_commit on Wiki "Laurenz Albe" <invite@spam.to.invalid> - 2011-05-03 10:29 +0200
    Re: synchronous_commit on Wiki Thomas Guettler <hv@tbz-pariv.de> - 2011-05-11 08:53 +0200

csiph-web