I have experiences of administration with MySQL and Oracle Database.
I started to work with PostgreSQL recently and cannot find the reason why PostgreSQL managing WAL files by removing or adding
according to setting with wal_keep_segments
, max_wal_size
and min_wal_size
.
MySQL just keeps on generaing new transaction files and Oracle rotates the trancation files with REDO log files and also archiving. I don't know why PostgreSQL managing WAL by changing the number of WAL files. Why not just keep the fixed number of WAL files?