Re: Fix documentation for max_wal_size and min_wal_size

Поиск
Список
Период
Сортировка
Искать
От
Kyotaro Horiguchi
Тема
Re: Fix documentation for max_wal_size and min_wal_size
Дата
Msg-id
20230414.170148.2094911529347990235.horikyota.ntt@gmail.com
Ответ на
Список
Дерево обсуждения
Fix documentation for max_wal_size and min_wal_size sirisha chamarthi <sirichamarthi22@gmail.com>
Re: Fix documentation for max_wal_size and min_wal_size Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Fix documentation for max_wal_size and min_wal_size sirisha chamarthi <sirichamarthi22@gmail.com>
Re: Fix documentation for max_wal_size and min_wal_size Michael Paquier <michael@paquier.xyz>
Re: Fix documentation for max_wal_size and min_wal_size sirisha chamarthi <sirichamarthi22@gmail.com>
Re: Fix documentation for max_wal_size and min_wal_size Michael Paquier <michael@paquier.xyz>
Re: Fix documentation for max_wal_size and min_wal_size Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Fix documentation for max_wal_size and min_wal_size Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Fix documentation for max_wal_size and min_wal_size Kyotaro Horiguchi <horikyota.ntt@gmail.com>
At Thu, 13 Apr 2023 12:01:04 -0700, sirisha chamarthi  wrote in 
> The documentation [1] says max_wal_size and min_wal_size defaults are 1GB
> and 80 MB respectively. However, these are configured based on the
> wal_segment_size and documentation is not clear about it. Attached a patch
> to fix the documentation.
> 
> [1] https://www.postgresql.org/docs/devel/runtime-config-wal.html

Good catch! Now wal_segment_size is easily changed.

-        The default is 1 GB.
+        The default value is configured to maximum of 64 times the wal_segment_size or 1 GB.
-        The default is 80 MB.
+        The default value is configured to maximum of 5 times the wal_segment_size or 80 MB.

However, I believe that most users don't change the WAL segment size,
so the primary information is that the default sizes are 1GB and 80MB.

So, I personally think it should be written like this: "The default
size is 80MB. However, if you have changed the WAL segment size from
the default of 16MB, it will be five times the segment size.", but I'm
not sure what the others think about this..

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center


В списке pgsql-hackers по дате отправления
От: Jim Jones
Дата:
От: Daniel Gustafsson
Дата:
FAQ