Thread: Indexing on a separate volume
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?
On Wed, 13 Jun 2001, mlw wrote: > I was thinking this morning, how much work would it be to change the directory > structure of Postgres. Another useful change would be the addition of directory splitting in the database directories. This will increase performance on operating systems whose filesystem performance drops dramatically with a large number of files (say, large objects) in a single directory. Gavin
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
> On Wed, 13 Jun 2001, mlw wrote: > > > I was thinking this morning, how much work would it be to change the directory > > structure of Postgres. > > Another useful change would be the addition of directory splitting in the > database directories. This will increase performance on operating systems > whose filesystem performance drops dramatically with a large number of > files (say, large objects) in a single directory. Good news is that in 7.1 large objects are all in one file. Again, see the TODO.detail about tablespaces. -- 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