well it depends , our D.B is really high in transactions, and checkpoints_segments along with the wal_buffers are ok. you need to play with both of them
On Wed, 2008-10-08 at 10:31 -0200, Rafael Domiciano wrote: > The server is running Postgres 8.2.4 > When the server is doing too much operations like I, U or D the > postgres stop a while each 5 min...! > I mean "stopping" that I don't receive any response from postgres, and > the process the all people are running stay there, waiting for > something. > I read a several names to it like: gap, stall, slowdown... I don't > know the write expression for this situation.
The bgwriter was added to help alleviate this problem.
What are your settings for that? The solution may be to push dirty buffers to disk more aggressively via the bgwriter so you have less work to do at checkpoint time.