Re: [HACKERS] no universally correct setting for fsync

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] no universally correct setting for fsync
Дата
Msg-id 4335.1273277612@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] no universally correct setting for fsync  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: [HACKERS] no universally correct setting for fsync  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-docs
Josh Berkus <josh@agliodbs.com> writes:
> This is what I have to replace the current fsync entry in config.sgml.

s/unexpected shutdown/system crash/, perhaps.  The wording you have
suggests that a forced Postgres stoppage produces a problem, which it
doesn't.  It takes a failure at the OS level or below to cause a
problem.

> I believe that the note about needing fsync for Warm Standby to work
> correctly is true, but could someone verify it?

AFAIK that's nonsense.  The filesystem state that pg_standby could see
will be updated in any case; pg_standby has no direct access to the bits
on the platters, any more than Postgres does.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [HACKERS] no universally correct setting for fsync
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [HACKERS] no universally correct setting for fsync