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