[postgis-users] radically different performance on different machines

[Richard Greenwood]

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?

Thanks,
Rich

select pidn, accountno, owner, address, address2,
       st_address, descript, wkb_geometry, row_number() OVER (ORDER BY
pidn) AS row_number
       from ownership_export,
    (SELECT special_districts.name,
      st_buffer(special_districts.wkb_geometry, (-5)::double precision) AS
geom,
      row_number() OVER (ORDER BY special_districts.name) AS row_number
     FROM special_districts
     WHERE name = 'Teton Village Resort District'
    ) as sd_buffer
where st_intersects(ownership_export.wkb_geometry, sd_buffer.geom);

-- ownership_export is a view: parcel_combined + parcel_attrib



-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131108/b4396f2b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fast.png
Type: image/png
Size: 26637 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131108/b4396f2b/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: slow.png
Type: image/png
Size: 19974 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131108/b4396f2b/attachment-0001.png>