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

Server process

From: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Server process
Date: 2004-05-25 02:54:46
Message-ID: 200405250241.i4P2fMhv001672@mail.census.gov.ph (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

 

How can I automatically kill a process in the database (ex a select or
explain) if it exceeds my limit of 2 or 3 mins ..

 For example : I have a query that already running for 3 or 4 mins I want to
kill that process for a reason and return a

Signal to the user.

 

Thanks

Michael 

Responses

pgsql-performance by date

Next:From: Christopher Kings-LynneDate: 2004-05-25 03:05:37
Subject: Re: Server process
Previous:From: Tom LaneDate: 2004-05-25 01:22:38
Subject: Re: index's relpages after table analyzed

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