Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Thomas Guettler Newsgroups: comp.databases.postgresql Subject: synchronous_commit on Wiki Date: Mon, 02 May 2011 16:44:54 +0200 Lines: 18 Message-ID: <927ub6F3drU1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: individual.net Lyqw9AXmdz35SWH7XbCZmg7IGDnNdf+EGfYPPtIUwqffOZ3Cw= Cancel-Lock: sha1:OyGLG+heIkzgh3spntsOtUuXzSg= 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 Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:107 Hi, 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". Thomas -- Thomas Guettler, http://www.thomas-guettler.de/ E-Mail: guettli (*) thomas-guettler + de