[postgis-users] ST_Estimated_Extent return incorrect result

Denis Rykov rykovd at gmail.com
Fri Aug 27 11:27:47 PDT 2010


1. psql -h gis-lab.info -U guest -d osm -c "SELECT ST_Extent(the_geom)
FROM all_bounds"
return correct result:
                    st_extent
-------------------------------------------------
 BOX(-180 35.1298141384262,180 85.4657795616266)
(1 row)

2. psql -h gis-lab.info -U guest -d osm -c "SELECT
ST_Estimated_Extent('public','all_bounds','the_geom')"
return incorrect result:
                     st_estimated_extent
-------------------------------------------------------------
 BOX(-98.0144271850586 35.129810333252,180 85.4657821655273)
(1 row)

Try to use VACUUM ANALYZE - no results.



More information about the postgis-users mailing list