Re: Terrible performance on wide selects - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Terrible performance on wide selects
Date
Msg-id 25521.1043280242@sss.pgh.pa.us
Whole thread Raw
In response to Re: Terrible performance on wide selects  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: Terrible performance on wide selects  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
"Dann Corbit" <DCorbit@connx.com> writes:
> Maybe I don't really understand the problem, but it seems simple enough
> to do it once for the whole query.

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.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order