Re: Tables in one disk and indexes in another ??

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Gastón Simone <gaston(at)apraful(dot)com(dot)uy>
Subject: Re: Tables in one disk and indexes in another ??
Date: 2004-08-06 18:14:10
Message-ID: 4113CA72.9060505@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ron St-Pierre 2004-08-06 18:19:23 Re: lock entire database
Previous Message Gaetano Mendola 2004-08-06 17:58:21 Re: lock entire database