| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
| Cc: | frank church <pgsql(at)adontendev(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Does VACUUM reorder tables on clustered indices |
| Date: | 2005-12-18 22:01:39 |
| Message-ID: | 20051218220139.GA1651@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-12-19 01:32:39 | Re: [pgadmin-hackers] Client-side password encryption |
| Previous Message | Martin Marques | 2005-12-18 21:41:28 | Re: Does VACUUM reorder tables on clustered indices |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-12-19 02:19:04 | Re: Need SQL Help Finding Current Status of members |
| Previous Message | Martin Marques | 2005-12-18 21:41:28 | Re: Does VACUUM reorder tables on clustered indices |