hi, (on postgres 9.6) I was just practicing to make my no. of wal files in pg_xlog directory to be the same/equal as I pass on wal_keep_segments paramater. say for example show wal_keep_segments; wal_keep_segments ------------------- 125 so I want my wal files should not be grow in numbers more than 125 so for that I have changed the parameter of max_wal_size to 2 GB to limit the size of pg_xlog directory. show max_wal_size; max_wal_size -------------- 2GB (1 row) but I did some testing by bulk inserts then the number of wal files has grown more than 125. and the size of pg_xlog directory also reached to 2.7 GB. /data/apps/edb/as96/data/pg_xlog 04:05:08]$ ls | wc -l 173 /data/apps/edb/as96/data 04:05:11]$ du -sh pg_xlog/ 2.7G pg_xlog/ I wonder why I faced such behavior bcz I limited the size of pg_xlog directory by setting max_wal_size to 2GB that should be equivalent to around 125 number of wal file in the pg_xlog directory. please suggest how should I make both identical (wal_keep_segments and max_wal_size). regards, Atul
