Luis Amigo wrote: > I would keep an eye on backend's mem usage, don't let them get out of memory > nor go to swap. > I would consider increasing wal_files, i think postmaster is telling you every > minute
Actually, checkpoint_segments is the critical parameter when you have lots of activity and are checkpointing too often. wal_files is longer significant because we reuse WAL files. I think it may be removed in 7.3 anyway. I want to add this information to hardware performance tuning paper. -- 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
