Re: Another try at reducing repeated detoast work for PostGIS
| От | Tom Lane |
|---|---|
| Тема | Re: Another try at reducing repeated detoast work for PostGIS |
| Дата | |
| Msg-id | 10470.1250959181@sss.pgh.pa.us обсуждение |
| Ответ на | Re: Another try at reducing repeated detoast work for PostGIS (Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk>) |
| Ответы |
Re: Another try at reducing repeated detoast work for
PostGIS
|
| Список | 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 по дате отправления: