[postgis-users] Increase query performance

[Mark Cave-Ayland]

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.


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

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