Re: [GENERAL] performance versus order of fields in row

2003-11-25 Thread Tom Lane
Jan Wieck <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> 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" fie

Re: [GENERAL] performance versus order of fields in row

2003-11-25 Thread Jan Wieck
Tom Lane wrote: "D. Stimits" <[EMAIL PROTECTED]> 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 clustere

Re: [GENERAL] performance versus order of fields in row

2003-11-25 Thread Tom Lane
"D. Stimits" <[EMAIL PROTECTED]> 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 ge