Postgres Pro
Downloads
Home   >   mailing lists

Re: Tables in one disk and indexes in another ?? - Mailing list pgsql-novice

From Gaetano Mendola
Subject Re: Tables in one disk and indexes in another ??
Date
Msg-id 4113CA72.9060505@bigfoot.com
Whole thread Raw
In response to Tables in one disk and indexes in another ??  (Gastón Simone <gaston@apraful.com.uy>)
List pgsql-novice
Tree view 
Gastón Simone wrote:

> I have unly one database and two disks. In order to use all my hardware
> resources I want to store (for example) the tables in one of the disks and
> the indexes in the other one. How can I do that?

Using the tablespace feature in the future 8.0 version or right now
with help of symlink. However a suggest you to put in the other disk
just the WAL:  directory  data/pg_xlog



Regards
Gaetano Mendola

pgsql-novice by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: lock entire database
Next
From: Gaetano Mendola
Date:
Subject: Re: lock entire database