Re: How many fields in a table are too many - Mailing list pgsql-general

From Tom Lane
Subject Re: How many fields in a table are too many
Date
Msg-id 24818.1056825787@sss.pgh.pa.us
Whole thread Raw
In response to Re: How many fields in a table are too many  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: How many fields in a table are too many  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> However, I am not sure how useful NOT NULL is in practice because there
> are lots of columns that don't specify NOT NULL but have mostly nulls or
> mostly non-nulls, which kills our caching --- what I was hoping to do
> some day was to cache the null bitmask and offsets of the previous tuple
> and use those if the new tuple has the same null bitmask as the previous
> tuple.

We already cache fairly effectively in cases where there are no nulls.
I'm not sure it's worth trying to do something with the idea that two
adjacent tuples might have nulls in the same places.

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: How many fields in a table are too many
Next
From: Bruce Momjian
Date:
Subject: Re: How many fields in a table are too many