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?