Re: Status of index location patch

Vadim,

I guess I am still confused...

In dbcommands.c resolve_alt_dbpath() takes the db oid as a argument. 
This number is used to "find" the directory where the data files live. 
All the patch does is put the indexes into a "db oid"_index directory
instead of "db oid"


This is for tables  snprintf(ret, len, "%s/base/%u", prefix, dboid);
This is for indexes snprintf(ret, len, "%s/base/%u_index", prefix,
dboid);

And in catalog.c
tables: sprintf(path, "%s/base/%u/%u", DataDir, rnode.tblNode,
rnode.relNode);
indexes: sprintf(path, "%s/base/%u_index/%u", DataDir,                               rnode.tblNode,rnode.relNode);

Can you explain how I would get the tblNode for an existing database
index files  if it doesn't have the same OID as the database entry in
pg_databases.

Jim


> > Just wondering what is the status of this patch.  Is seems from
comments
> > that people like the idea.  I have also looked in the archives for
other
> > people looking for this kind of feature and have found alot of
interest.
> > 
> > If you think it is a good idea for 7.2, let me know what needs to be
> > changed and I will work on it this weekend.
> 
> Just change index' dir naming as was already discussed.
> 
> Vadim
> 
>