Re: Proposal for Null Bitmap Optimization(for TrailingNULLs) - Mailing list pgsql-hackers

From Decibel!
Subject Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)
Date
Msg-id 8488A285-D027-4467-8F66-A788887D0B3F@decibel.org
Whole thread Raw
In response to Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Responses Re: Proposal for Null Bitmap Optimization(for TrailingNULLs)  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
List pgsql-hackers
On Dec 20, 2007, at 2:36 AM, Gokulakannan Somasundaram wrote:
> I checked it by creating a table with 10 columns on a 32 bit
> machine. i inserted 100,000 rows with trailing nulls and i observed
> savings of 400Kbytes.


That doesn't really tell us anything... how big was the table
originally? Also, testing on 64 bit would be interesting.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: function body actors (was: [PERFORM] viewing source code)
Next
From: Marc Munro
Date:
Subject: Re: function body actors (was: [PERFORM] viewing source code)