Group Commits Vs WAL Writes

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Group Commits Vs WAL Writes
Дата
Msg-id CAOeZVidRgO9rgWA_xw1MfANX=vn6e-w0jNS6m_7kTLyc4gRbPA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Group Commits Vs WAL Writes  (Robert Haas <robertmhaas@gmail.com>)
Re: Group Commits Vs WAL Writes  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
Hi all,

I think this is a naive question.

When we do a commit, WAL buffers are written to the disk. This has a
disk latency for the required I/O.

Now, with group commits, do we see a spike in that disk write latency,
especially in the cases where the user has set wal_buffers to a high
value?


Regards,

Atri

--
Regards,

Atri
l'apprenant



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: refresh materialized view concurrently
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: MD5 aggregate