It is a good idea. See the web-based TODO list under tablespaces for a
discussion.
> 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?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
