Re: Dept of ugly hacks: eliminating padding space in system indexes

Поиск
Список
Период
Сортировка
От Stephen R. van den Berg
Тема Re: Dept of ugly hacks: eliminating padding space in system indexes
Дата
Msg-id 20080624211947.GA25769@cuci.nl
обсуждение исходный текст
Ответ на Re: Dept of ugly hacks: eliminating padding space in system indexes  (Mark Mielke <mark@mark.mielke.cc>)
Список pgsql-hackers
Mark Mielke wrote:
>saved - we're talking about 154 Kbytes saved on both those indices 
>combined. Minor? Major? I bet I wouldn't notice unless my database 
>requirements used up all RAM, and even then I'm suspecting it wouldn't 
>matter except for border line cases (like all pages required for 
>everything else happened to equal 4 Gbytes near exactly).

There is always only so much of 1st level and 2nd level cache; for those
the savings might well make a difference, even on multigigabyte
databases.
-- 
Sincerely,          Stephen R. van den Berg.

Life is that brief interlude between nothingness and eternity.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jeffrey Baker"
Дата:
Сообщение: Re: proposal for smaller indexes on index-ordered tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout