[postgis-users] radically different performance on different machines

[Sandro Santilli]

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;