start here http://www.postgresql.org/docs/8.1/static/creating-cluster.html M- ----- Original Message ----- From: "Erik Jones" <erik@xxxxxxxxxx> To: "Rainer Bauer" <usenet@xxxxxxxxxx> Cc: <pgsql-general@xxxxxxxxxxxxxx> Sent: Wednesday, November 28, 2007 5:59 PM Subject: Re: Cluster using tablespaces? 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@xxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
