[GENERAL] shared_buffers smaller than max_wal_size

Поиск
Список
Период
Сортировка
От Vladimir Mihailenco
Тема [GENERAL] shared_buffers smaller than max_wal_size
Дата
Msg-id CAGzYotcP78vG51KbFCRwQhR0exMPNSW76xbKm+Lf_3050V0U8w@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения
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?

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

Предыдущее
От: Miloslav Semler
Дата:
Сообщение: Re: [GENERAL] Question about SELECT statements with subselects
Следующее
От: mike davis
Дата:
Сообщение: [GENERAL] Re: Dynamic use of RAISE with USING to generate and catchnon-hardcoded custom exceptions