Re: Asynchronous commit | Transaction loss at server crash

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Asynchronous commit | Transaction loss at server crash
Дата
Msg-id AANLkTilevLpYSpa7e_6vJ_snoOeXnF3kaVqxmydjYF3G@mail.gmail.com
обсуждение исходный текст
Ответ на Asynchronous commit | Transaction loss at server crash  (Balkrishna Sharma <b_ki@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Clarification Needed: When does autovacuum daemon run?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Asynchronous commit | Transaction loss at server crash