Re: [PATCHES] CLUSTER not lose indexes
От | Bruce Momjian |
---|---|
Тема | Re: [PATCHES] CLUSTER not lose indexes |
Дата | |
Msg-id | 200207161541.g6GFfiq26196@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [PATCHES] CLUSTER not lose indexes (Curt Sampson <cjs@cynic.net>) |
Ответы |
Re: [PATCHES] CLUSTER not lose indexes
|
Список | 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 по дате отправления: