Re: Does VACUUM reorder tables on clustered indices - Mailing list pgsql-sql

From Martin Marques
Subject Re: Does VACUUM reorder tables on clustered indices
Date
Msg-id Pine.LNX.4.61.0512181840350.20029@bugs.unl.edu.ar
Whole thread Raw
In response to Does VACUUM reorder tables on clustered indices  (frank church <pgsql@adontendev.net>)
Responses Re: Does VACUUM reorder tables on clustered indices  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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
---------------------------------------------------------

pgsql-sql by date:

Previous
From: frank church
Date:
Subject: Does VACUUM reorder tables on clustered indices
Next
From: Alvaro Herrera
Date:
Subject: Re: Does VACUUM reorder tables on clustered indices