Re: Cluster using tablespaces?

[Erik Jones <erik(at)myemma(dot)com>]

On Nov 28, 2007, at 4:47 PM, Rainer Bauer wrote:

> Hello,
>
> 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?
>
> Rainer

What temporary created data are you referring to?  Do you mean the  
contents of the the other cluster directories such as pg_xlog?  If  
so, there's no need.  Just make it a symlink to a directory on other  
disks and you're done.  If that's not what you mean, can you explain  
further?

Erik Jones

Software Developer | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com