Re: [postgis-users] Query slow down, never completes - Mailing list pgsql-general

From Sandro Santilli
Subject Re: [postgis-users] Query slow down, never completes
Date
Msg-id 20111011150817.GF23739@gnash
Whole thread Raw
Responses Re: [postgis-users] Query slow down, never completes
List pgsql-general
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.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Should casting to integer produce same result as trunc()
Next
From: Achilleas Mantzios
Date:
Subject: Re: Global Variables?