Thanks for all the suggestions.
I first thought about doing the simplify, but after some reconsideration I
realized that this would change the geometry of the country borders, and
Area measurements might be wrong.
Then i tried the query without the ST_Intersection and only the conditional
ST_Inter
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.
gt; http://www.postgis.us
>
>
> __
> From: Andreas Forø Tollefsen [mailto:andrea...@gmail.com]
> Sent: Tuesday, March 08, 2011 12:02 PM
> To: PostGIS Users Discussion
> Cc: Paragon Corporation
> Subject: Re: [post
rs Discussion
Cc: Paragon Corporation
Subject: Re: [postgis-users] Increase query performance
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.
L
ing about here? What's the max number of
>>> points you have in any geometry. Often times its just one huge mega
>>> geometry with a 100,000 points or more slowing everything down.
>>>
>>> Do you have indexes on your year fields and date columns?
>>>
>>> Hope that helps,
>>
ope that helps,
>> Regina
>> http://www.postgis.us
>>
>>
>> --
>> *From:* postgis-users-boun...@postgis.refractions.net [mailto:
>> postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Andreas
>> Forø Tollefsen
>> *
hat helps,
> Regina
> http://www.postgis.us
>
>
> --
> *From:* postgis-users-boun...@postgis.refractions.net [mailto:
> postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Andreas Forø
> Tollefsen
> *Sent:* Tuesday, March 08, 2011 4:15 AM
> *To:* PostGIS Users Disc
users-boun...@postgis.refractions.net] On Behalf Of Andreas
Forø Tollefsen
Sent: Tuesday, March 08, 2011 4:15 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Increase query performance
Hi all,
Another question on postgis query performance. I did some discussion on the
pgsql performance l
Hi all,
Another question on postgis query performance. I did some discussion on the
pgsql performance list on how i could increase the performance on my server.
I did manage to increase the transactions per second, but came to the
conclusion that this did not help the ST_Intersection query which i
