Re: Group Commits Vs WAL Writes

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Re: Group Commits Vs WAL Writes
Дата
Msg-id CAOeZVidycMg891PwyKDEo_+8SEQwct_guCPzFCBA7AKh_NgQ_A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Group Commits Vs WAL Writes  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Group Commits Vs WAL Writes  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
> Well, it does take longer to fsync a larger byte range to disk than a
> smaller byte range, in some cases.  But it's generally more efficient
> to write one larger range than many smaller ranges, so you come out
> ahead on the whole.

Right, that does make sense.

So, the overhead of writing a lot of WAL buffers is mitigated because
one large write is better than lots of smaller rights?

Regards,

Atri


--
Regards,

Atri
l'apprenant



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

Предыдущее
От: Atri Sharma
Дата:
Сообщение: Re: Group Commits Vs WAL Writes
Следующее
От: Andres Freund
Дата:
Сообщение: Re: extensible external toast tuple support