[postgis-users] Query slow down, never completes
strk at keybit.net
Tue Oct 11 08:08:17 PDT 2011
On Tue, Oct 11, 2011 at 02:25:20PM +0200, Andreas Forø Tollefsen wrote:
> I also tried to close the db1 connection for each year in the loop, and
> reopen the connection for the next year in the loop. Same problem.
> I have tried both with insert into ... select .. and select into annual
> tables and the put them together. Same problem.
Then I guess the problem is with the specific data you encounter
at the given year. Can you reproduce the hangup in the query for
a single year ? Keep an eye on memory use and CPU utilization.
() Free GIS & Flash consultant/developer
More information about the postgis-users