Re: performance versus order of fields in row

Tom Lane wrote:

>"D. Stimits" <stimits@comcast.net> writes:
>
>
>>I'm not looking for an exact answer here, but instead something more
>>"rule of thumb". If I have a table with many fields, and I retrieving
>>small groups of fields during a SELECT, whereby the groups of fields are
>>indexed and/or clustered, will I get a faster select in the left-most
>>fields, or the right-most fields? Or will it not matter?
>>
>>
>
>Fields earlier in the table definition (further to the left) are
>marginally faster to access than ones further to the right.  I doubt it
>would be real noticeable unless you had hundreds of fields altogether.
>

Do we still "cache" field offsets for not-nullable-fixed-size columns?


Jan

--

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