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.


Thu, 16 Jan 2003 10:40:04 -0500
mlw <pgsql@mohawksoft.com>
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.

My guess is that having indexes at separate location on a per-databases basis would give greater benefit. Perhaps this could be extended to all databases as well, but per-database location should be better?

Or do you think of something like data/base/xxxxx/indx where xxxxx is the database oid.

Daniel


Thu, 16 Jan 2003 20:41:33 +0200
Daniel Kalchev <daniel@digsys.bg>
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

Thu, 16 Jan 2003 14:13:21 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Indexes 
On Thu, 16 Jan 2003, Tom Lane wrote:

> > 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.

Wasn't someone just about done with a tablespace implementation? I certainly
remember some discussion on this subject a few months ago.


-- 
Nigel J. Andrews


Thu, 16 Jan 2003 22:05:02 +0000 (GMT)
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: Indexes