| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)atentus(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] CLUSTER not lose indexes |
| Date: | 2002-07-16 08:59:46 |
| Message-ID: | Pine.NEB.4.44.0207161758150.465-100000@angelic.cynic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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.
cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-16 13:31:47 | Re: pg_views.definition |
| Previous Message | Luis Alberto Amigo Navarro | 2002-07-16 08:51:03 | Re: [HACKERS] please help on query |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgsql-bugs | 2002-07-16 12:41:23 | Bug #712: Documentation Section 3.4 Binary Strings |
| Previous Message | Tom Lane | 2002-07-16 06:40:00 | Re: several minor cleanups |