Re: [GENERAL] Running with fsync=off

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Running with fsync=off
Дата
Msg-id 21388.1135799920@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Running with fsync=off  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Список pgsql-admin
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> But in our 7.4.x, there is code like this:

>  sync();
>  if (IsUnderPostmaster)
>   sleep(2);
>  sync();

I'm not claiming that that code is correct; it is in fact just as broken
as the traditional custom.  You'll notice we don't have it anymore ;-)

> Why wasting 2 seconds is enough to save the data?

It's not.  The entire custom is and always has been bogus.

            regards, tom lane

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

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: [GENERAL] Running with fsync=off
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: preventing deadlocks