Groups > comp.databases.postgresql > #112

Re: synchronous_commit on Wiki

From	"Laurenz Albe" <invite@spam.to.invalid>
Newsgroups	comp.databases.postgresql
References	<927ub6F3drU1@mid.individual.net>
Subject	Re: synchronous_commit on Wiki
Date	2011-05-03 10:29 +0200
Organization	dienste.wien.at ISP
Message-ID	<1304411410.99095@proxy.dienste.wien.at> (permalink)

Show all headers | 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