On Thu, Jan 31, 2019 at 11:52 AM rammohan ganapavarapu <rammohanganap@xxxxxxxxx> wrote: > But from postgres documentation "The number of WAL segment files in pg_xlog directory depends on min_wal_size, max_wal_size and the amount of WAL generated in previous checkpoint cycles. You are quoting from the v10+ documentation but using 9.6 You also need to read about archiving[1] since when it is enabled the rules for WAL retention are modified to meet the needs of archiving, specifically WAL cannot be removed from the host system until the host's archiving system knows that the same file exists in the archive. [1] https://www.postgresql.org/docs/9.6/continuous-archiving.html#BACKUP-ARCHIVING-WAL David J.