From: | "Martin Gainty" <mgainty(at)hotmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Cluster using tablespaces? |
Date: | 2007-11-28 23:07:50 |
Message-ID: | BAY108-DAV12A5DC4CFDC8FF037323DCAE770@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
start here
http://www.postgresql.org/docs/8.1/static/creating-cluster.html
M-
----- Original Message -----
From: "Erik Jones" <erik(at)myemma(dot)com>
To: "Rainer Bauer" <usenet(at)munnin(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, November 28, 2007 5:59 PM
Subject: Re: [GENERAL] 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(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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Rainer Bauer | 2007-11-28 23:10:43 | Re: Cluster using tablespaces? |
Previous Message | Erik Jones | 2007-11-28 22:59:13 | Re: Cluster using tablespaces? |