Re: How are NULLS stored on disk for PG 7.4?

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Yannick Warnier <ywarnier(at)beeznest(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How are NULLS stored on disk for PG 7.4?
Date: 2004-01-15 21:34:20
Message-ID: 4007075C.1090706@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yannick Warnier wrote:

> Le mar 13/01/2004 à 00:43, Bruce Momjian a écrit :
>> Arnold Mavromatis wrote:
>> > Hi
>> >
>> > How are column files in a table that have been assigned null stored on disk
>> > in Postgresql 7.4?
>>
>> Each row has a bitmap showing all the NULL values on that row.
>
> Is it the same for PG 7.3?

It has always been that way. But the bitmap is only there if there is at
least one NULL value. One bit in the tuple headers flags tells if there
is a bitmap or not.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-15 22:00:06 Re: why isn't TEXT a key word?
Previous Message Tom Lane 2004-01-15 21:32:12 Re: Bytea/Large Objects/external files best practices