Re: [PERFORM] synchronous_commit off

2011-08-02 Thread lars hofhansl
. From: Anibal David Acosta a...@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

[PERFORM] synchronous_commit off

2011-08-01 Thread Anibal David Acosta
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

Re: [PERFORM] synchronous_commit off

2011-08-01 Thread Greg Smith
On 08/01/2011 09:29 AM, Anibal David Acosta wrote: 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. No. You are turning off the wait for the transaction to hit

Re: [PERFORM] synchronous_commit off

2011-08-01 Thread Anibal David Acosta
: lunes, 01 de agosto de 2011 03:53 p.m. Para: pgsql-performance@postgresql.org Asunto: Re: [PERFORM] synchronous_commit off On 08/01/2011 09:29 AM, Anibal David Acosta wrote: Can a transaction committed asynchronously report an error, duplicate key or something like that, causing a client

Re: [PERFORM] synchronous_commit off

2011-08-01 Thread Craig Ringer
On 2/08/2011 3:52 AM, Greg Smith wrote: On 08/01/2011 09:29 AM, Anibal David Acosta wrote: 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. No. You are turning