Re: Recommended value for pg_test_fsync

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Re: Recommended value for pg_test_fsync
Дата
Msg-id CAFpL5VyfH9OENa1=wkVT6cYwiC4xWthqi4fKZFcYfeMUjbnF=w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recommended value for pg_test_fsync  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-performance
Hi Bruce,

Thank you. We may stick with fdatasync for now.

Thanks and regards,
Nikhil

On Tue, Jun 30, 2020 at 8:54 PM Bruce Momjian <bruce@momjian.us> wrote:
On Tue, Jun 30, 2020 at 10:32:13AM +0530, Nikhil Shetty wrote:
> Hi Bruce,
>
> Based on pg_test_fsync results, should we choose open_datasync or fdatasync as
> wal_sync_method? Can we rely on pg_test_fsync for choosing the best

I would just pick the fastest method, but if the method is _too_ fast,
it might mean that it isn't actually writing to durable storage.

> wal_sync_method or is there any other way?

pg_test_fsync is the only way I know of, which is why I wrote it.

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Recommended value for pg_test_fsync
Следующее
От: Nikhil Shetty
Дата:
Сообщение: Re: Recommended value for pg_test_fsync