On Mar 21, 11:36 am, [EMAIL PROTECTED] (Bill Eaton) wrote:
I want to allow some queries for my users to run for a prescribed period of
time and kill them if they go over time. Is there a good way to do this? Or
is this a bad idea?
I've been struggling with trying to figure out the best way to
I want to allow some queries for my users to run for a prescribed period of
time and kill them if they go over time. Is there a good way to do this? Or
is this a bad idea?
I've been struggling with trying to figure out the best way to allow users
to browse through large tables. For example, I
Bill Eaton [EMAIL PROTECTED] writes:
I want to allow some queries for my users to run for a prescribed period of
time and kill them if they go over time. Is there a good way to do this?
set statement_timeout perhaps?
regards, tom lane
---(end of
I want to allow some queries for my users to run for a prescribed period
of
time and kill them if they go over time. Is there a good way to do this?
set statement_timeout perhaps?
Ooh. I like that. It would be absolutely brilliant if I could figure out how
to get it to work with ADO and the
Bill Eaton wrote:
I want to allow some queries for my users to run for a prescribed period
of
time and kill them if they go over time. Is there a good way to do this?
set statement_timeout perhaps?
Ooh. I like that. It would be absolutely brilliant if I could figure out how
to get it to
I want to allow some queries for my users to run for a
prescribed period of time and kill them if they go over
time. Is there a good way to do this?
set statement_timeout perhaps?
I don't think you can set GUC parameters from the ODBC driver. Your
options are:
* postgresql.conf. Will
On Mar 21, 2007, at 3:09 PM, Bill Eaton wrote:
I want to allow some queries for my users to run for a prescribed
period
of
time and kill them if they go over time. Is there a good way to
do this?
set statement_timeout perhaps?
Ooh. I like that. It would be absolutely brilliant if I
[EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, March 21, 2007 4:04 PM
Subject: Re: [GENERAL] best way to kill long running query?
I want to allow some queries for my users to run for a
prescribed period of time and kill them if they go over
time