From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | docs should mention that max_wal_size default depends on WAL segment size |
Date: | 2018-11-18 21:16:12 |
Message-ID: | 2daad013-75d7-6c6f-2165-417a6d082300@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
while investigating something on a cluster with a non-default WAL
segment (say 256MB), I've noticed a somewhat surprising behavior of
max_wal_size default. While the docs claim the default is 1GB, the
actual default depends on the WAL segment size.
For example with the 256MB WAL segments, you end up with this:
test=# show max_wal_size ;
max_wal_size
--------------
16GB
(1 row)
This behavior is not entirely new - I've noticed it on 10, before the
WAL segment size was moved to initdb (which made it more likely to be
used). It's even more surprising there, because it leaves
#max_wal_size = 1GB
in the sample config, while fc49e24f at least emits the actual value.
But I'd say not mentioning this behavior in the docs is a bug.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2018-11-18 21:20:37 | Re: Fixing AC_CHECK_DECLS to do the right thing with clang |
Previous Message | Andres Freund | 2018-11-18 20:38:01 | Re: _isnan() on Windows |