Skip site navigation (1) Skip section navigation (2)

Re: Postgresq 8,1 hangs when running function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "ben sewell" <mosherben(at)gmail(dot)com>
Cc: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgresq 8,1 hangs when running function
Date: 2006-08-21 13:58:38
Message-ID: 11296.1156168718@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"ben sewell" <mosherben(at)gmail(dot)com> writes:
> what I meant was that when I tried executing my function, postgres wouldn't
> return any results and not do anything. CPU Usage would increase to 50% when
> I tried executing the function. The funny thing is that CPU usage was at
> 100% and the sys admin called me up and asked about it. Apparently there
> were 10 instances of postgres running so we ended up having to restart
> anyways.

There are much less aggressive ways of canceling a long-running query
than restarting the whole server.  On Windows I think you need to do
"pg_ctl kill INT <processID>" to stop a query running in a particular
backend process.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Sean DavisDate: 2006-08-21 14:08:24
Subject: Re: Postgresq 8,1 hangs when running function
Previous:From: ben sewellDate: 2006-08-21 13:31:37
Subject: Re: Postgresq 8,1 hangs when running function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group