Indexing on a separate volume

From: mlw <markw(at)mohawksoft(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Indexing on a separate volume
Date: 2001-06-13 12:35:16
Message-ID: 3B275E04.31F8ECD4@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was thinking this morning, how much work would it be to change the directory
structure of Postgres.

from:

postgres/
base/
db1/
db2/
db3/
...
pg_xlog/

to

postgres/
base/
db1/
db2/
db3/
...
index/
db1/
db2/
db3/
...
pg_xlog/

Or
postgres/
base/
db1/
data/
index/
db2/
data/
index/
db3/
data/
index/
...
pg_xlog/

This sort of arangment would allow putting indexes on separate volumes. If it
is a stupid idea, with little value or a huge amount of work, I take it back.
Seriously, however, does it make any sense?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2001-06-13 13:12:05 Re: Re: REPLACE INTO table a la mySQL
Previous Message The Hermit Hacker 2001-06-13 11:55:32 Re: AW: vacuum