Search Postgresql Archives

shared_buffers smaller than max_wal_size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: shared_buffers smaller than max_wal_size
From: Vladimir Mihailenco <vladimir.webdev@xxxxxxxxx>
Date: Fri, 22 Sep 2017 14:28:38 +0300

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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Prev by Date: Re: VM-Ware Backup of VM safe?
Next by Date: errors on COMMIT and transaction states
Previous by thread: Question about SELECT statements with subselects
Next by thread: shared_buffers smaller than max_wal_size
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux