Re: [HACKERS] Status of index location patch

2001-09-15 Thread Vadim Mikheev
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

Re: [HACKERS] Status of index location patch

2001-09-15 Thread Chamanya
On Saturday 15 September 2001 03:03, Jim Buttafuoco wrote: 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. Can we have a

Re: [HACKERS] Status of index location patch

2001-09-15 Thread Jim Buttafuoco
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

Re: [HACKERS] Status of index location patch

2001-09-15 Thread Vadim Mikheev
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. Well, keeping in mind future tablespace implementation I would add tblNode to pg_class and in pg_databases I'd have defaultTblNode and

Re: [HACKERS] Status of index location patch

2001-09-15 Thread Jim Buttafuoco
Yes that is exactly what I am going to do for 7.3 (had trouble adding tblNode to pg_class so I stopped for now...) 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. Well, keeping in

[HACKERS] Status of index location patch

2001-09-14 Thread Jim Buttafuoco
All, 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