Postgres Pro
Downloads
Home   >   mailing lists

Indexing on a separate volume - Mailing list pgsql-hackers

From mlw
Subject Indexing on a separate volume
Date
Msg-id 3B275E04.31F8ECD4@mohawksoft.com
Whole thread Raw
Responses Re: Indexing on a separate volume  (Gavin Sherry <swm@linuxworld.com.au>)
Re: Indexing on a separate volume  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
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?

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: AW: vacuum
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: AW: Postgres Replication