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

From: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Dept of ugly hacks: eliminating padding space in system indexes
Date: 2008-06-24 21:19:47
Message-ID: 20080624211947.GA25769@cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-06-24 21:34:50 Re: [HACKERS] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout
Previous Message Jeffrey Baker 2008-06-24 21:08:43 Re: proposal for smaller indexes on index-ordered tables