Postgres Pro
Downloads
Home   >   mailing lists

pg_wal directory max size - Mailing list pgsql-general

From Yi Sun
Subject pg_wal directory max size
Date
Msg-id CABWY_HA20HSPk+E7TpeiUqXext=wTfU08YZbemReX908AgGgmQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_wal directory max size  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: pg_wal directory max size  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Dan Langille
Date:
Subject: Re: tsvector not giving expected results on one host
Next
From: David Rowley
Date:
Subject: Re: Implementing foreign data wrappers and avoiding n+1 querying