Home > mailing lists

Server process - Mailing list pgsql-performance

From	Michael Ryan S. Puncia
Subject	Server process
Date	May 25, 2004 02:50:20
Msg-id	200405250241.i4P2fMhv001672@mail.census.gov.ph Whole thread Raw
Responses	Re: Server process (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List	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

From: Tom Lane
Date: 25 May 2004, 01:23:00
Subject: Re: index's relpages after table analyzed

From: Christopher Kings-Lynne
Date: 25 May 2004, 03:01:15
Subject: Re: Server process