Postgres Pro
Downloads
Home   >   mailing lists

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 CAHeEsBe8pY0Mu4CrSwOu23bHds-pJZfcxuFQC1Cx8jJ2Eea3dQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Does having a NULL column automatically exclude thetable from the tupleDesc cache?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [HACKERS] Does having a NULL column automatically exclude thetable from the tupleDesc cache?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Tree view

attcacheoff can only be set positive for fields preceding any varlena
(typlen<0, but including the first such) or nullable values.  I don't
know how much faster it is with the cache; you can measure it if your
curiosity is strong enough -- just set the first column to nullable.


Thanks!  Maybe I'll do some benchmarks.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Parallel Index-only scan
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Should we cacheline align PGXACT?