>>>Hannu Krosing said: > Tom Lane kirjutas N, 23.01.2003 kell 02:04: > > We already do cache column offsets when they are fixed. The code that's > > the problem executes when there's a variable-width column in the table > > --- which means that all columns to its right are not at fixed offsets, > > and have to be scanned for separately in each tuple, AFAICS. > > Not only varlen columns, but also NULL columns forbid knowing the > offsets beforehand.
Does this mean, that constructing tables where fixed length fields are 'before' variable lenght fields and 'possibly null' fields might increase performance? Daniel ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
