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(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026