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

Re: Reduce per tuple overhead (bitmap)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Reduce per tuple overhead (bitmap)
Date: 2002-05-27 20:39:10
Message-ID: 27163.1022531950@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> This small patch makes the length of the null bitmap a multiple
> of 1 byte (has been a multiple of 4 bytes previously), thus saving
> MAXIMUM_ALIGNOF (4 or 8 on modern platforms) bytes per on-disk-tuple
> in certain cases (depending on number of attributes and if there is
> at least one null attribute).
> Though it changes the on-disk-format, there's no need to initdb,
> because data offsets are stored in t_hoff for each tuple.  So this
> patch can be applied to HEAD and to the 7.2 branch.

I've applied this to CVS tip.  I do not think it is appropriate for
7.2 branch, however, since it's not a bug fix.

			regards, tom lane

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2002-05-27 21:15:21
Subject: Re: COPY and default values
Previous:From: Peter EisentrautDate: 2002-05-27 20:29:23
Subject: Re: SSL (patch 5)

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