pg_wal directory max size

From: Yi Sun <yinan81(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pg_wal directory max size
Date: 2022-12-22 03:00:57
Message-ID: CABWY_HA20HSPk+E7TpeiUqXext=wTfU08YZbemReX908AgGgmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello guys,

We are planning the server disk space, pg_wal directory max size is wal
file size*wal_keep_segments? or is it also decided by other parameters
please? We tried to search for this, but could not find the answer

For example our postgresql is 9.6 below parameters value, is the pg_wal
directory max size 320*16MB please? Thank you
wal file size 16MB
wal_keep_segments = 320
min_wal_size = 1GB
max_wal_size = 2GB

Best Regards
Dennis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2022-12-22 03:56:30 Re: Implementing foreign data wrappers and avoiding n+1 querying
Previous Message Dan Langille 2022-12-22 00:55:13 Re: tsvector not giving expected results on one host