Re: Checkpoint cost, looks like it is WAL/CRC

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: Checkpoint cost, looks like it is WAL/CRC
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57945BAFB@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Checkpoint cost, looks like it is WAL/CRC  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Checkpoint cost, looks like it is WAL/CRC  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
>>> The point here is that fsync-off is only realistic for development
or
>>> playpen installations.  You don't turn it off in a production
>>> machine, and I can't see that you'd turn off the full-page-write
>>> option either.  So we have not solved anyone's performance problem.
>
>> Yes, this is basically another fsync-like option that isn't for
>> production usage in most cases.  Sad but true.
>
> Just to make my position perfectly clear: I don't want to see
> this option shipped in 8.1.

Why not ? If your filesystem buffer size matches your pg page size,
and you have a persistent write cache, the option makes perfect sense.

Andreas


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

Предыдущее
От: James William Pye
Дата:
Сообщение: Re: process crash when a plpython function returns
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Checkpoint cost, looks like it is WAL/CRC