Re: Dept of ugly hacks: eliminating padding space in system indexes - Mailing list pgsql-hackers

From Stephen R. van den Berg
Subject Re: Dept of ugly hacks: eliminating padding space in system indexes
Date
Msg-id 20080624211947.GA25769@cuci.nl
Whole thread Raw
In response to Re: Dept of ugly hacks: eliminating padding space in system indexes  (Mark Mielke <mark@mark.mielke.cc>)
List 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 by date:

Previous
From: "Jeffrey Baker"
Date:
Subject: Re: proposal for smaller indexes on index-ordered tables
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout