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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
