On 24 Feb 2003, Ericson Smith wrote:
>
> > From 7.3 to 7.4 the biggest changes planned so far:
> > - windows native support <-- gartner gives it a 90% chance of making it
> > into the main disto... :-)
> > - fix for in() performance issue <-- already in CVS tip
> > - partitioning or tablespaces <-- who know? seriously, who?
> > - vacuum will be able to compact out unused space <-- Tom Lane
>
> Will we be able to run the new vacuum system without locking the tables?
Vacuum only locks the tables now for a second or so.
You might want to look at using regular vacuums more often. In my
testing, vacuum (non full) uses <2% of the CPU on a heavily loaded server.
Between the low load of vacuum and having higher fsm settings, you might
obviate the need to regular vacuum any more than once a day or week or
whatever.