Re: [SQL] Record size

2003-06-11 Thread Josh Berkus
Hilary, > Firstly an apology - I think this should be posted to the performance > mailing list but can anyone tell me how to subscribe to this please? The > usual form to fill in is not available on the website. Hopefully others in > this list will find the answer of use though. To: [EMAIL PROT

Re: [SQL] Record size

2003-06-11 Thread Tom Lane
Hilary Forbes <[EMAIL PROTECTED]> writes: > Now the question. Does the number of fields that you have in a record and indeed > their size affect performance on a SELECT statement when only a subset of fields is > being extracted? So suppose that I have > f1 integer > f2 varchar(4) >

[SQL] Record size

2003-06-11 Thread Hilary Forbes
Firstly an apology - I think this should be posted to the performance mailing list but can anyone tell me how to subscribe to this please? The usual form to fill in is not available on the website. Hopefully others in this list will find the answer of use though. Now the question. Does the n