Re: improving write performance for logging

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: improving write performance for logging
Дата
Msg-id 22489.1136579266@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: improving write performance for logging  (Ian Westmacott <ianw@intellivid.com>)
Список pgsql-performance
Ian Westmacott <ianw@intellivid.com> writes:
> If the WAL is lost, can you lose more than the data since the last
> checkpoint?

The problem is that you might have partially-applied actions since the
last checkpoint, rendering your database inconsistent; then *all* the
data is suspect if not actually corrupt.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow query. Any way to speed up?
Следующее
От: peter royal
Дата:
Сообщение: help tuning queries on large database