Re: AW: [HACKERS] Re: [GENERAL] drop/rename table and transactions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: AW: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Date
Msg-id 199912011749.MAA23293@candle.pha.pa.us
Whole thread Raw
In response to AW: [HACKERS] Re: [GENERAL] drop/rename table and transactions  (Zeugswetter Andreas SEV <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
> > This doesn't solve Vadim's problem.  His additional work would be to
> > write a line to the log file for each table create/delete saying I
> > deleted this table with this oid, and when reading back the 
> > log, he has
> > to record the oid_username combination and use that to 
> > translate his log
> > oids into actual filenames.
> 
> Why that ? 
> 
> 24323_* will point to the correct table segments inside the db directory.
> No need to actually know what * matches to, no ?

True.  If we go with tablename_OID format, then vadim will have to scan
directory and pick up all his oids and map them to file names before
spinning through the log.  Yes, it is a little more work, but worth it.

If you put the oid at the beginning, it is easier, but it is still an
issue because you have to issues a scandir command to find the matching
name for each oid.  Actually, he can do that no matter where the oid is
stored in the name.  That may be the way he has to handle it.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@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
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Next
From: Bruce Momjian
Date:
Subject: Re: [ADMIN] When postgres will be faster?