On Fri, Nov 08, 2013 at 07:58:45AM -0700, Richard Greenwood wrote: > I have a query that runs in <1 second on one machine and 47 seconds on > another. The postgres and postgis versions are bascially the same. The > database and query are the same. But "explain" is different on the two. The > query is below and the graphic output of pgAdmin explain is attached. > Obviously, my question is - why the difference?
Different statistics gathered ? Try running ANALYZE on both systems. Different cost configuration ? Compare postgresql.conf. --strk; _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
