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 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> 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 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