In response to Robert Fitzpatrick <[EMAIL PROTECTED]>: > On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote: > > That doesn't mean you're vacuuming often enough, however. Switch your > > nightly vacuum to vacuum verbose and capture the output to see how much > > work it has to do. Are your fsm settings high enough?
<snip> > INFO: free space map contains 30078 pages in 41 relations > DETAIL: A total of 30304 page slots are in use (including overhead). > 30304 page slots are required to track all free space. > Current limits are: 204800 page slots, 1000 relations, using 1265 kB. This was what I was most concerned about. If your FSM settings are too low, vacuum won't be able to fully do its job. But it looks like you're OK here. -- Bill Moran http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
