Re: Adding BUFFERS slowed Checkpoints

You increased your buffers by about 5, so your checkpoint increased by about 5. Sounds like your system is writing about 100 pages per second. That seems pretty slow. What kind of disks are you using? RAID 5? Are you getting disk contention? (More than one busy table on one disk or partition?) I have set the LRU_MAX and MIN to as low as 1 and 0 in an attempt to reduce checkpoint times. (We had a real slow disk configuration.) This essentially forced the engine to write all the time and checkpoints were very quick because there was very little to do. It helped a batch load run a little quicker, but I went back to 3/2 (or maybe 2/1) when the load was done.