Re: State of Beta 2 - Mailing list pgsql-general

From Bruce Momjian
Subject Re: State of Beta 2
Date
Msg-id 200309121422.h8CEMWB14200@candle.pha.pa.us
Whole thread Raw
In response to Re: State of Beta 2  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: State of Beta 2  (Manfred Koizar <mkoi-pg@aon.at>)
Re: State of Beta 2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Manfred Koizar wrote:
> On Thu, 11 Sep 2003 14:24:25 -0700, Sean Chittenden
> <sean@chittenden.org> wrote:
> >Agreed, but if anyone has a table with close to 1600 columns in a
> >table...
>
> This 1600 column limit has nothing to do with block size.  It is
> caused by the fact that a heap tuple header cannot be larger than 255
> bytes, so there is a limited number of bits in the null bitmap.

Are you sure.  Then our max would be:

    255 * 8 = 2040

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: [PORTS] plPHP for windows
Next
From: Manfred Koizar
Date:
Subject: Re: State of Beta 2