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 CAGzYotcRpCwjmPV80_A7xojrfGsZY1g81GVMjGazd1NvUJ-j0A@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] shared_buffers smaller than max_wal_size  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
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: Tim Uckun
Date:
Subject: [GENERAL] Why can't the database owner create schemas and how can I enable that?
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] Why can't the database owner create schemas and how canI enable that?