Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #107 > unrolled thread
| Started by | Thomas Guettler <hv@tbz-pariv.de> |
|---|---|
| First post | 2011-05-02 16:44 +0200 |
| Last post | 2011-05-11 08:53 +0200 |
| Articles | 3 — 2 participants |
Back to article view | Back to comp.databases.postgresql
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
| From | Thomas Guettler <hv@tbz-pariv.de> |
|---|---|
| Date | 2011-05-02 16:44 +0200 |
| Subject | synchronous_commit on Wiki |
| Message-ID | <927ub6F3drU1@mid.individual.net> |
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
[toc] | [next] | [standalone]
| From | "Laurenz Albe" <invite@spam.to.invalid> |
|---|---|
| Date | 2011-05-03 10:29 +0200 |
| Message-ID | <1304411410.99095@proxy.dienste.wien.at> |
| In reply to | #107 |
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
[toc] | [prev] | [next] | [standalone]
| From | Thomas Guettler <hv@tbz-pariv.de> |
|---|---|
| Date | 2011-05-11 08:53 +0200 |
| Message-ID | <92uq3pFnajU1@mid.individual.net> |
| In reply to | #112 |
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
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.postgresql
csiph-web