Re: Limiting processor power on queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chad Thompson" <chad(at)weblinkservices(dot)com>
Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Limiting processor power on queries
Date: 2003-05-13 23:09:56
Message-ID: 19216.1052867396@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Chad Thompson" <chad(at)weblinkservices(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Yovko Ilchev Yovkov 2003-05-14 04:41:47 Insert on create table
Previous Message Katy Earl 2003-05-13 22:25:17 Re: can't alter user with the postgres user