On 22 December 2022 04:00:57 CET, Yi Sun <yina...@gmail.com> wrote: >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
No, you need space to store all wal's between 2 checkpoints. So it depends more on the checkpoint parameters and your workload. Plus wal_keep_segments... 9.6 is out of support. Andreas
