Re: [postgis-users] Query slow down, never completes

Поиск
Список
Период
Сортировка
От Sandro Santilli
Тема Re: [postgis-users] Query slow down, never completes
Дата
Msg-id 20111011151642.GG23739@gnash
обсуждение исходный текст
Ответ на Re: [postgis-users] Query slow down, never completes  (Andreas Forø Tollefsen <andreasft@gmail.com>)
Ответы Re: [postgis-users] Query slow down, never completes
Список 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 по дате отправления:

Предыдущее
От: Andreas Forø Tollefsen
Дата:
Сообщение: Re: [postgis-users] Query slow down, never completes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Should casting to integer produce same result as trunc()