Re: Does VACUUM reorder tables on clustered indices

Martin Marques escribió:
> On Sun, 18 Dec 2005, frank church wrote:
> 
> >
> >Does VACUUMing reorder tables on clustered indices or is it only the 
> >CLUSTER
> >command that can do that?
> 
> Cluster does that. Vacuum only cleans dead tuples from the tables.

Note that while reordering, CLUSTER also gets rid of dead tuples, so if
you cluster you don't need to vacuum.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.