[postgis-users] GiST

[Guido Staub]

David Blasby schrieb:

>Guido Staub wrote:
>
>  
>
>>aren't operators like &<, &>, >>, << implemented yet for GiST-Index Scan?
>>Trying a query with them and using explain I always get as result that
>>seq scan will be used and not index scan 
>>    
>>
>
>It should be indexed.  Try typing this before your query:
>
>'set enable_seqscan =off;'
>
>This forces the postgresql planner to use the index.  Postgresql is usually
>pretty bad a determining when to use the GiST index, hence all the traffic on
>histogram2ds to optimize use of the index with the "&&" operator 
>
>dave
>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>  
>
Now it works. Thanks.
But can you please give an example on how to use histogram2ds?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20021105/0ca2f7b7/attachment.html>