Re: Asynchronous commit | Transaction loss at server crash - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Asynchronous commit | Transaction loss at server crash
Date
Msg-id AANLkTilevLpYSpa7e_6vJ_snoOeXnF3kaVqxmydjYF3G@mail.gmail.com
Whole thread Raw
In response to Asynchronous commit | Transaction loss at server crash  (Balkrishna Sharma <b_ki@hotmail.com>)
List pgsql-admin
On Thu, May 20, 2010 at 10:54 AM, Balkrishna Sharma <b_ki@hotmail.com> wrote:
> Hello,
> Couple of questions:
> 1. For the 'Asynchronous commit' mode, I know that WAL transactions not
> flushed to permanent storage will be  lost in event of a server crash. Is it

That's not exactly correct.  Transactions that haven't been written to
WAL may be lost.  This would be a small number of transactions.
Transactions written to the WAL but not to the main data store will
NOT be lost.

However, this may still not be an acceptable case for your usage.

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Clarification Needed: When does autovacuum daemon run?
Next
From: Scott Marlowe
Date:
Subject: Re: Asynchronous commit | Transaction loss at server crash