[postgis-users] question on gist performance

[Frank Koormann]

Setfan,

* Stefan Zweig <stefanzweig1881 at web.de> [070907 11:36]:
> this what analyze says:

the following output looks like from EXPLAIN, not from EXPLAIN ANALYSE,
the actual timings, loops etc are missing. Could you please repost?

> "Index Scan using mytable_the_geom_gist on mytable  (cost=0.00..4.95 rows=1 width=13)"
> "  Index Cond: ....
> "  Filter: ...
> 
> "Index Scan using mytable_bbox_gist on mytable  (cost=0.00..4.95 rows=1 width=13)"
> "  Index Cond: (...
> "  Filter: (...

Also some version/platform information would help. Could you please post
the output of 
 select postgis_full_version();
and 
 select version();

Regards,

        Frank

-- 
Frank Koormann    |   ++49-541-335 08 30    |   http://www.intevation.net/
Intevation GmbH, Osnabrück, DE | Commercial Register Osnabrück, HR B 18998
Managing Directors: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
PostGIS Support (http://www.intevation.net/geospatial/postgis-support.en.html)