[postgis-users] GIST index

strk at refractions.net strk at refractions.net
Sat Feb 18 06:46:59 PST 2006


On Fri, Feb 17, 2006 at 02:51:22PM -0600, David Bitner wrote:
> Does the GIST index work for all of the operators, or just &&?

EXPLAIN should tell you. By disabling sequencial scan you can make
sure index is not skipped to to optimizer decision (custom statistics
are only used with &&).

--strk;



More information about the postgis-users mailing list