Groups > comp.databases.postgresql > #112

Re: synchronous_commit on Wiki

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder4.news.weretis.net!newsfeed.utanet.at!newscore.univie.ac.at!aconews-feed.univie.ac.at!aconews.univie.ac.at!not-for-mail
From	"Laurenz Albe" <invite@spam.to.invalid>
Newsgroups	comp.databases.postgresql
References	<927ub6F3drU1@mid.individual.net>
Subject	Re: synchronous_commit on Wiki
Date	Tue, 3 May 2011 10:29:47 +0200
X-Priority	3
X-MSMail-Priority	Normal
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-RFC2646	Format=Flowed; Original
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6090
Organization	dienste.wien.at ISP
Message-ID	<1304411410.99095@proxy.dienste.wien.at> (permalink)
X-Cache	nntpcache 2.3.3 (see http://www.nntpcache.org/)
Lines	19
NNTP-Posting-Host	141.203.254.23
X-Trace	1304411411 aconews.univie.ac.at 73248 141.203.254.23
X-Complaints-To	abuse@univie.ac.at
Xref	x330-a1.tempe.blueboxinc.net comp.databases.postgresql:112

Show key headers only | View raw

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

Yours,
Laurenz Albe

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next 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