shared_buffers smaller than max_wal_size

From: Vladimir Mihailenco <vladimir(dot)webdev(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: shared_buffers smaller than max_wal_size
Date: 2017-09-23 06:18:50
Message-ID: CAGzYotcRpCwjmPV80_A7xojrfGsZY1g81GVMjGazd1NvUJ-j0A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-09-23 06:33:54 Re: Why can't the database owner create schemas and how can I enable that?
Previous Message Tim Uckun 2017-09-23 05:29:46 Why can't the database owner create schemas and how can I enable that?