On Fri, Jun 08, 2007 at 05:11:44PM -0400, Ericson Smith wrote: > > Also, if you're updating that table frequently, lots of dead tuples > will remain in there if you don't do a VACUUM FULL regularly. No, they won't. No well-tuned postgres installation has needed VACUUM FULL in a long time. VACUUM FULL is there to save you if you've overshot the regular VACUUM capabilities. This is all explained in the manual. > You might also want to do a dump and restore as well to prevent > transaction wraparound. You better not need this any more, either, if you're doing regular VACUUM. That hasn't been a problem since 7.2. A -- Andrew Sullivan | ajs@xxxxxxxxxxxxxxx When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes
