Re: [HACKERS] Terrible performance on wide selects - Mailing list pgsql-performance

From Dann Corbit
Subject Re: [HACKERS] Terrible performance on wide selects
Date
Msg-id D90A5A6C612A39408103E6ECDD77B8294CD864@voyager.corporate.connx.com
Whole thread Raw
Responses Re: [HACKERS] Terrible performance on wide selects  (Hannu Krosing <hannu@tm.ee>)
List pgsql-performance
[snip]
> So (for instance) if you have 12 variable fields, you would
> store 12 integers at the start of the record.

Additionally, you could implicitly size the integers from the properties
of the column.  A varchar(255) would only need an unsigned char to store
the offset, but a varchar(80000) would require an unsigned int.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: relaxing link between explicit JOINs and execution order
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Terrible performance on wide selects