Re: Cluster using tablespaces?

Поиск
Список
Период
Сортировка
Искать
От
Rainer Bauer
Тема
Re: Cluster using tablespaces?
Дата
Msg-id
o5trk39r95e9ula42g8pileo5mu9p47abq@4ax.com
Список
Дерево обсуждения
Cluster using tablespaces? Rainer Bauer <usenet@munnin.com>
Re: Cluster using tablespaces? Erik Jones <erik@myemma.com>
Erik Jones wrote:

>> is there a way to instruct cluster to store the temporary created  
>> data on a
>> different tablespace (i.e. drive)? If not, wouldn't that have a decent
>> performance impact or is most of the time spend retrieving the data  
>> in index
>> order?
>
>What temporary created data are you referring to?

The one described in the manual
:

"During the cluster operation, a temporary copy of the table is created that
contains the table data in the index order. Temporary copies of each index on
the table are created as well."

Rainer
В списке pgsql-general по дате отправления
От: Martin Gainty
Дата:
Сообщение: Re: Cluster using tablespaces?
От: Tom Lane
Дата:
Сообщение: Re: Cluster using tablespaces?
FAQ