Обсуждение: [GENERAL] shared_buffers smaller than max_wal_size

Поиск
Список
Период
Сортировка

[GENERAL] shared_buffers smaller than max_wal_size

От
Vladimir Mihailenco
Дата:
Hi,

I wonder what is the point of setting max WAL size bigger than shared buffers, e.g.

shared_buffers = 512mb
max_wal_size = 2gb

As I understand a checkpoint happens after 2gb of data were modified (writter to WAL), but shared buffers can contain at most 512mb of dirty pages to be flushed to the disk. Is it still a win or I am missing something?