On Thu, May 20, 2010 at 10:54 AM, Balkrishna Sharma <b_ki@xxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
