Groups > comp.databases.postgresql > #119

Re: synchronous_commit on Wiki

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.news-service.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Thomas Guettler <hv@tbz-pariv.de>
Newsgroups	comp.databases.postgresql
Subject	Re: synchronous_commit on Wiki
Date	Wed, 11 May 2011 08:53:45 +0200
Lines	23
Message-ID	<92uq3pFnajU1@mid.individual.net> (permalink)
References	<927ub6F3drU1@mid.individual.net> <1304411410.99095@proxy.dienste.wien.at>
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-15
Content-Transfer-Encoding	8bit
X-Trace	individual.net /Hcg1uELEjpOYmkPMKOXxQx2wDAczCKA+rDX03k5UduGMbrQM=
Cancel-Lock	sha1:clc50YB6rSiA9aYsJK6vgV1PVfU=
User-Agent	Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.1.16) Gecko/20101125 SUSE/3.0.11 Thunderbird/3.0.11
In-Reply-To	<1304411410.99095@proxy.dienste.wien.at>
Xref	x330-a1.tempe.blueboxinc.net comp.databases.postgresql:119

Show key headers only | 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