"Vance Maverick" <[EMAIL PROTECTED]> writes:
> Do I have this right? If so, the side table sounds like the right choice
No, if the null bit is set then the field isn't stored at all. You don't pay
the alignment or storage overhead at all.
The only cost is for the null bitmap itself. If you
I have a table with lots and lots of rows (into the millions), and I want to
add some information to it. The new data consists of a VARCHAR and a BYTEA,
and it will almost always be null -- let's say only one row in 10,000 will have
non-null values. I'm trying to decide whether to add the new
