On Sun, May 15, 2005 at 08:26:02PM -0700, Josh Berkus wrote: > David, > > > I've seen these messages in the log before, and am aware of the need to > > increase checkpoint_segments, but I wasn't aware that recycling a > > transaction log could be that damaging to performance. There may have > > been some local hiccup in this case, but I'm wondering if recycling is > > known to be a big hit in general, and if I should strive to tune so that > > it never happens (if that's possible)? > > Yes, and yes. Simply allocating more checkpoint segments (which can eat a > lot of disk space -- requirements are 16mb*(2 * segments +1) ) will prevent > this problem.
Advertising
Hmm? I disagree -- it will only make things worse when the checkpoint does occur. -- Alvaro Herrera (<alvherre[a]surnet.cl>) "Lo esencial es invisible para los ojos" (A. de Saint Exúpery) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
