Re: Indexing on a separate volume

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