Re: 7.4?

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.