Re: Status of index location patch

Jim, do you have an updated patch that you would like applied for 7.3?


---------------------------------------------------------------------------

Jim Buttafuoco wrote:
> 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
> > 
> > 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us 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