Re: Changing default value of wal_sync_method to open_datasync on Linux

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Changing default value of wal_sync_method to open_datasync on Linux
Дата
Msg-id CA+TgmoY6LG1Ptr2N2K1a5nMu1VMCKEi5DvV0XZKFXmJfnJmLFw@mail.gmail.com
обсуждение исходный текст
Ответ на Changing default value of wal_sync_method to open_datasync on Linux  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Ответы Re: Changing default value of wal_sync_method to open_datasync on Linux  ("MauMau" <maumau307@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Mon, Feb 19, 2018 at 7:27 PM, Tsunakawa, Takayuki
<tsunakawa.takay@jp.fujitsu.com> wrote:
> The reason for change is better performance.  Robert Haas said open_datasync was much faster than fdatasync with
NVRAMin this thread:
 

I also said it would be worse on spinning disks.

Also, Yoshimi Ichiyanagi did not find it to be true even on NVRAM.

Changing the default requires a lot more than one test result where a
non-default setting is better.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] VACUUM and ANALYZE disagreeing on what reltuples means
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Typo with pg_multixact/offset in multixact.c