> This would need to be done to implement some sort of tablespace-style
> facility, too, right? I'm off Xun's thread in asking but I've been
> wondering. DBs like Oracle allow you to place tables and indices
> whereever you like in the filesystem. This is normally done to
> distribute things across different spindles, and in large, busy
> databases makes a significant difference. I've done some experimenting
> moving index files to a different spindle (using "ln" to fool
> postgres, of course) and insertions go measurably faster. Spindles
> are so cheap nowadays :)
WAL will add the oid to the base file name. That may make tablespaces
easier.
-- Bruce Momjian | http://www.op.net/~candle 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