Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group