Re: [HACKERS] [hackers]development suggestion needed

> 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