Re: Indexes

> mlw said:
>>> Does anyone think it would be a good idea, or is it even practical, to 
>>> have a 'indx' subdirectory along side of the 'base' directory?
>>> 
>>> I was thinking that, if it were an easy modification, that it could be 
>>> an easy way to separate data and indexes to different hard disks.

This and other quick hacks have been discussed before.  I think the
consensus has been to do nothing until someone gets around to writing
a general-purpose tablespace implementation.

FWIW, I don't think it would be an easy modification.  The low-level
file access code doesn't even know whether a given relation is an index
or not (... and I don't think it should know).  By the time you get done
implementing something reasonable at that level, you've got the
infrastructure you need for tablespaces.
        regards, tom lane