Re: Another try at reducing repeated detoast work for PostGIS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Another try at reducing repeated detoast work for PostGIS
Date
Msg-id 10470.1250959181@sss.pgh.pa.us
Whole thread Raw
In response to Re: Another try at reducing repeated detoast work for PostGIS  (Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk>)
Responses Re: Another try at reducing repeated detoast work for PostGIS  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-hackers
Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk> writes:
> So in conclusion, I think that patch looks good and that the extra time 
> I was seeing was due to RECHECK being applied to the && operator, and 
> not the time being spent within the index scan itself.

Thanks, I appreciate the followup.

I plan to go ahead and apply the patch to HEAD --- it doesn't conflict
with Heikki's pending patch AFAICS, and no one has suggested an
alternative that seems likely to get implemented soon.

I am a bit tempted to apply it to 8.4 as well; otherwise the PostGIS
people are likely to start cluttering their code with this
add-a-dummy-function workaround, which would be unproductive in the long
run.  Comments?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Resjunk sort columns, Heikki's index-only quals patch, and bug #5000
Next
From: Caleb Welton
Date:
Subject: Re: [PATCH] plpythonu datatype conversion improvements