Re: Cluster using tablespaces? - Mailing list pgsql-general

From Rainer Bauer
Subject Re: Cluster using tablespaces?
Date
Msg-id o5trk39r95e9ula42g8pileo5mu9p47abq@4ax.com
Whole thread Raw
In response to Cluster using tablespaces?  (Rainer Bauer <usenet@munnin.com>)
Responses Re: Cluster using tablespaces?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Martin Gainty"
Date:
Subject: Re: Cluster using tablespaces?
Next
From: Tom Lane
Date:
Subject: Re: Cluster using tablespaces?