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
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?