[postgis-devel] Re: [postgis-users] GIST index speed

[Tom Lane]

Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk> writes:
> ... The question is: what can we do about this, especially as this is a very 
> common case within PostGIS? According to the thread on -hackers, Tom 
> suggested it may be possible to get PostgreSQL to automatically de-TOAST 
> index scan keys. Unfortunately while this would solve the problem, it 
> requires some non-trivial development work (i.e. it isn't exactly clear 
> how to do it), and wouldn't help existing users.

I think I might have scared you off a bit too much there.  My impression
of this problem is that it should be just a few lines of code to fix;
I'm just not instantly sure of where to put those lines.

			regards, tom lane