Re: Server process - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: Server process
Date
Msg-id 40B2B801.9020201@familyhealth.com.au
Whole thread Raw
In response to Server process  ("Michael Ryan S. Puncia" <mpuncia@census.gov.ph>)
List pgsql-performance
Read the docs on going SET statement_timeout TO ...;

Chris

Michael Ryan S. Puncia wrote:

>
>
> 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
>

pgsql-performance by date:

Previous
From: "Michael Ryan S. Puncia"
Date:
Subject: Server process
Next
From: Jochem van Dieten
Date:
Subject: Re: PostgreSQL caching