Re: [PATCHES] CLUSTER not lose indexes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] CLUSTER not lose indexes
Date
Msg-id 200207161541.g6GFfiq26196@candle.pha.pa.us
Whole thread Raw
In response to Re: [PATCHES] CLUSTER not lose indexes  (Curt Sampson <cjs@cynic.net>)
Responses Re: [PATCHES] CLUSTER not lose indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Curt Sampson wrote:
> On Mon, 15 Jul 2002, Bruce Momjian wrote:
> 
> > > (In related news, how about filling up the oid/relfilenode numbers with
> > > zeros on the left, so a directory listing would reflect the numerical
> > > order?)
> >
> > Problem there is that we increase the size of much of the directory
> > lookups.  Not sure if it is worth worrying about.
> 
> Probably not such a big deal, since most systems will be reading
> a full block (8K or 16K under *BSD) to load the directory information
> anyway. Doing it in hex would give you only 8-char filenames, anyway.

Yes, hex may be interesting as a more compact, consistent format.  We
need to change the docs so oid2name and queries convert to hex on
output.

--  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
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] line datatype
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] CLUSTER not lose indexes