Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] shared_buffers smaller than max_wal_size - Mailing list pgsql-general

From Vladimir Mihailenco
Subject [GENERAL] shared_buffers smaller than max_wal_size
Date
Msg-id CAGzYotcP78vG51KbFCRwQhR0exMPNSW76xbKm+Lf_3050V0U8w@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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 by date:

Previous
From: Miloslav Semler
Date:
Subject: Re: [GENERAL] Question about SELECT statements with subselects
Next
From: mike davis
Date:
Subject: [GENERAL] Re: Dynamic use of RAISE with USING to generate and catchnon-hardcoded custom exceptions