Re: [HACKERS] Does having a NULL column automatically exclude thetable from the tupleDesc cache? - Mailing list pgsql-hackers

From Ryan Murphy
Subject Re: [HACKERS] Does having a NULL column automatically exclude thetable from the tupleDesc cache?
Date
Msg-id CAHeEsBcx-v+JmsWuXMnCdnVduhuavtYiHpLhj=Kwab0MCm65Hw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Does having a NULL column automatically exclude the table from the tupleDesc cache?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Does having a NULL column automatically exclude thetable from the tupleDesc cache?
List pgsql-hackers

No, that tests whether the particular tuple contains any null fields, not
whether the whole table is declared NOT NULL.

                        regards, tom lane

Ok, thanks, that makes sense.

My question kind of remains though - does that mean that having any nulls in the tuple loses the ability to use the tupleDesc cache? and how much of a performance impact is this?  I'm sure there's a good reason why you can't really use the cache if you have a null column, just was curious of the implications.  Thanks again!

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Does having a NULL column automatically exclude the table from the tupleDesc cache?
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Should we cacheline align PGXACT?