Re: how unsafe (or worst scenarios) when setting fsync

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: how unsafe (or worst scenarios) when setting fsync
Дата
Msg-id 11142.1146149866@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: how unsafe (or worst scenarios) when setting fsync  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: how unsafe (or worst scenarios) when setting fsync  ("Guoping Zhang" <guoping.zhang@nec.com.au>)
Список pgsql-performance
Simon Riggs <simon@2ndquadrant.com> writes:
> On Thu, 2006-04-27 at 16:31 +1000, Guoping Zhang wrote:
>> Can we set fsync OFF for the performance benefit, have the risk of only 5
>> minutes data loss or much worse?

> Thats up to you.

> fsync can be turned on and off, so you can make critical changes with
> fsync on, then continue with fsync off.

I think it would be a mistake to assume that the behavior would be
nice clean "we only lost recent changes".  Things could get arbitrarily
badly corrupted if some writes make it to disk and some don't.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Large (8M) cache vs. dual-core CPUs