In response to Ron St-Pierre <ron.pgsql@xxxxxxx>: > Bill Moran wrote: > > In response to Ron St-Pierre <ron.pgsql@xxxxxxx>: > > > > > >> We vacuum only a few of our tables nightly, this one is the last one > >> because it takes longer to run. I'll probably re-index it soon, but I > >> would appreciate any advice on how to speed up the vacuum process (and > >> the db in general). > >> > > > > I doubt anyone can provide meaningful advice without the output of > > vacuum verbose. Understood, however I may have spoken too soon. It appears that Tom found an obvious issue with your config that seems likely to be the problem. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@xxxxxxxxxxxxxxxxxxxxxxx Phone: 412-422-3463x4023 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
