Re: cluster questions

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: cluster questions
Дата
Msg-id Pine.NEB.4.51.0302240952470.659@angelic-vtfw.cvpn.cynic.net
обсуждение исходный текст
Ответ на cluster questions  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
On Sat, 21 Feb 2003, Greg Stark wrote:

> Cluster has to sort the whole table (or do an index scan) and reorganize the
> data in the table. Does it do this by copying the data?

Yes,.

> Is that effectively
> the same as a vacuum full as far as the resulting space usage?

Yes.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

В списке pgsql-general по дате отправления:

Предыдущее
От: _
Дата:
Сообщение: ignore previous message NOTICE: Could not select primary index key
Следующее
От: Hadley Willan
Дата:
Сообщение: Why are absolute paths considered a security risk?