Setfan,
* Stefan Zweig <[EMAIL PROTECTED]> [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)
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
