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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] line datatype
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] CLUSTER not lose indexes