Re: Cost limit. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Cost limit.
Date
Msg-id 20289.990205239@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cost limit.  (Shaun Thomas <sthomas@townnews.com>)
List pgsql-admin
Shaun Thomas <sthomas@townnews.com> writes:
>> Note you could implement such a time limit purely on the client side,
>> which might be an easier and more flexible way to go.

> That's just it.  PHP (our front end) has a 30 second time limit we
> have not overridden.  But we've found that after the PHP execution stops
> in disgust, the postgres thread keeps going until we restart the
> postgres back end.

Sounds like PHP is not actually trying to cancel the query when it
gives up waiting.  Anyone care to go in and fix that?

            regards, tom lane

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: user delete problem
Next
From: Jeremy Ashcraft
Date:
Subject: Error help