Shridhar Daithankar wrote:
> Looks like we should have a subdirectory in database directory which stores
> index.

That was my first thought also, but an alternative/additional approach
would be this (not sure if it's workable):

 - As each index already has a bunch of information stored stored for
it, would it be possible to have an additional column added called
'idxpath' or something?

 - This would mean that the index location would be stable per index,
and would allow for *really* high volume environments to keep different
indexes on different drives.

Not sure what the default value would be, maybe the PGDATA directory,
maybe something as a GUC variable, etc, but that's the concept.


Regards and best wishes,

Justin Clift

> May be transaction logs, indexes goes in separte directory which can be
> symlinked. Linking a directory is much simpler solution than linking a file.
> I suggest we have per database transaction log and indexes created in separate
> subdirectories for each database. Furhter given that large tables are segmented
> after one GB size, a table should have it's own subdirectory optionally..
> At the cost of few inodes, postgresql would gain much more flexibility and
> hence tunability..
> May be TODO for 7.4? Anyone?
> Bye
>  Shridhar
> --
> Software, n.:   Formal evening attire for female computer analysts.
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to