Re: synchronous_commit off
| От | lars hofhansl |
|---|---|
| Тема | Re: synchronous_commit off |
| Дата | |
| Msg-id | 1312330088.11904.YahooMailNeo@web121712.mail.ne1.yahoo.com обсуждение исходный текст |
| Ответ на | synchronous_commit off ("Anibal David Acosta" <aa@devshock.com>) |
| Список | pgsql-performance |
No: The commit has the same guarantees as a synchronous commit w.r.t. data consistency. The commit can only fail (as a whole) due to hardware problems or postgres backend crashes.
And yes: The client commit returns, but the server can fail later and not persist the transaction and it will be lost (again as a whole).
Your application should be able to tolerate losing the latest committed transactions if you use this.
The difference to fsync=off is that a server crash will leave the database is a consistent state with just the latest transactions lost.
From: Anibal David Acosta <aa@devshock.com>
To: pgsql-performance@postgresql.org
Sent: Monday, August 1, 2011 6:29 AM
Subject: [PERFORM] synchronous_commit off
Can a transaction committed asynchronously report an error, duplicate key or something like that, causing a client with a OK transaction but server with a FAILED transaction.
Thanks
В списке pgsql-performance по дате отправления: