[postgis-users] Increase query performance

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Wed Mar 9 01:55:53 PST 2011

On 08/03/11 17:01, Andreas Forø Tollefsen wrote:

> After a suggestion from pgsql_performance i tried with ST_Simplify to
> speed things up.
> However this gives me a:
> NOTICE: ptarray_simplify returned a <2 pts array
> Then server connection terminates.
> Like this:
> SELECT ST_Intersection(priogrid_land.cell,
> ST_Simplify(cshapeswdate.geom,0.1)) AS geom,
> priogrid_land.gid AS divider, gwcode, gwsyear, gweyear, startdate,
> enddate, capname, caplong, caplat, col, row, xcoord, ycoord
> FROM priogrid_land, cshapeswdate WHERE ST_Intersects(priogrid_land.cell,
> ST_Simplify(cshapeswdate.geom,0.1)) AND cshapeswdate.gwsyear <=1946 AND
> cshapeswdate.gweyear >=1946 AND cshapeswdate.startdate <= '1946/1/1';

Yup that's a bug related to the new code in trunk - I think we've 
already got something similar filed in the bug tracker. This is probably 
going to require a Paul to take a look at it.



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs

More information about the postgis-users mailing list