Re: Does VACUUM reorder tables on clustered indices

Поиск
Список
Период
Сортировка
От Martin Marques
Тема Re: Does VACUUM reorder tables on clustered indices
Дата
Msg-id Pine.LNX.4.61.0512181840350.20029@bugs.unl.edu.ar
обсуждение исходный текст
Ответ на Does VACUUM reorder tables on clustered indices  (frank church <pgsql@adontendev.net>)
Ответы Re: Does VACUUM reorder tables on clustered indices  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: frank church
Дата:
Сообщение: Does VACUUM reorder tables on clustered indices
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Does VACUUM reorder tables on clustered indices