Olivier PRENANT wrote: > Hi every one. > > I just moved (at last!) to 7.2.1. Works like a charm... > I'm suprised though by the number of WAL files. > > I have 8 files where postgresql.conf says WAL_FILES=4. > > What did I miss ? (I have no outstanding transaction) > > FWIW, t's on UW711.
No, you are fine. The current GUC params are confusing. I did update the documentation for 7.3, but I plan to reorganize those params to be more meaningful. Actually, I have in TODO: Remove wal_files postgresql.conf option because WAL files are now recycled because the param no longer controls what you think it controls. In 7.1 WAL files where not recycled, so WAL_FILES was used to pre-allocate files so there wasn't as much happening during checkpoint. Now, with recycling, there is no need. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
