Re: Mapping tables to disk drives

Richard Emberson wrote:
> Are there any guides, references, etc. for helping someone:
> 1) know how to map a particular table to a particular disk drive (is it
> just symbolic links) and

Yep, just symlinks. We know we need a better method. Also, as the
table grows, extent files for >1gb will also need to be symlinked.

> 2) for what type of queries and table layout combination would it make
> sense to do so?

First, pg_xlog/ should be on a separate drive. Then you can think about
moving indexes and tables to separate drives.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026