| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | frank church <pgsql(at)adontendev(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Does VACUUM reorder tables on clustered indices |
| Date: | 2005-12-18 21:41:28 |
| Message-ID: | Pine.LNX.4.61.0512181840350.20029@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
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.
--
18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-12-18 22:01:39 | Re: Does VACUUM reorder tables on clustered indices |
| Previous Message | frank church | 2005-12-18 21:12:05 | Does VACUUM reorder tables on clustered indices |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-12-18 22:01:39 | Re: Does VACUUM reorder tables on clustered indices |
| Previous Message | frank church | 2005-12-18 21:12:05 | Does VACUUM reorder tables on clustered indices |