On Thu, 2007-11-08 at 12:02 -0500, Bill Moran wrote: > Frequently, when people ask for help because they've exceed max_fsm*, > it's because they're not paying attention to their systems, and therefore > the problem has been occurring for a while before it got so bad that > they couldn't ignore it. As a result, a full vacuum is frequently a > necessity. > > Folks who are monitoring their databases closely don't hit this > problem nearly as often. >
How does one monitor it closely anyway? the warning comes when one does a vacuum verbose and with autovacuum turned on, I don't even see it anywhere. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
