Re: [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)

From: Decibel! <decibel(at)decibel(dot)org>
To: Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
Cc: "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org>, pgsql-patches(at)postgresql(dot)org, "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: [HACKERS] Proposal for Null Bitmap Optimization(for TrailingNULLs)
Date: 2007-12-21 23:13:54
Message-ID: 8488A285-D027-4467-8F66-A788887D0B3F@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Munro 2007-12-22 00:28:12 Re: function body actors (was: [PERFORM] viewing source code)
Previous Message Joshua D. Drake 2007-12-21 22:07:08 Re: function body actors (was: [PERFORM] viewing source code)

Browse pgsql-patches by date

  From Date Subject
Next Message Dhanaraj M 2007-12-22 04:58:38 Re: Doc-patch: PAM authentication fails for local UNIX users
Previous Message Tom Lane 2007-12-21 03:37:58 Re: typo in func.sgml