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
<http://www.postgresql.org/docs/8.2/static/sql-cluster.html>:

"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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to