Re: Limiting processor power on queries - Mailing list pgsql-novice

From Tom Lane
Subject Re: Limiting processor power on queries
Date
Msg-id 19216.1052867396@sss.pgh.pa.us
Whole thread Raw
In response to Limiting processor power on queries  ("Chad Thompson" <chad@weblinkservices.com>)
List pgsql-novice
"Chad Thompson" <chad@weblinkservices.com> writes:
> 1) Is there some way to kill a query in 7.3?

That's been in there for a *long* time.

> 2) Is there a way to limit the processing power for a query based on a) from
> where the query originated (eg. IP address) or b) the type of query it is.

No.  In 7.3 you can set a per-statement timeout, although it's not
something you could enforce against an uncooperative user.

            regards, tom lane


pgsql-novice by date:

Previous
From: "Fontenot, Paul"
Date:
Subject: Functions and triggers
Next
From: Katy Earl
Date:
Subject: Re: can't alter user with the postgres user