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 20111011151642.GG23739@gnash
Whole thread Raw
In response to Re: [postgis-users] Query slow down, never completes  (Andreas Forø Tollefsen <andreasft@gmail.com>)
Responses Re: [postgis-users] Query slow down, never completes
List pgsql-general
On Tue, Oct 11, 2011 at 05:12:24PM +0200, Andreas Forø Tollefsen wrote:
> Hi Sandro,
>
> What i find strange is that it stops processing at different years on my
> desktop and my laptop. While my desktop stops processing at 1980, my slower
> laptop goes on to 1991 before halting.
> I also tried with different postgresql.conf shared_buffers settings without
> making any difference.
> Therefore it is hard to reproduce this for a single year. I can easily
> process 1980 or 1991 if just running the script for that year.

But you mentioned you had stopped the backend and restarted for each year ?
Does the problem still occur if you avoid writing any table (could be an I/O
issue) ?

--strk;

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

pgsql-general by date:

Previous
From: Andreas Forø Tollefsen
Date:
Subject: Re: [postgis-users] Query slow down, never completes
Next
From: Tom Lane
Date:
Subject: Re: Should casting to integer produce same result as trunc()