Re: Server process

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Server process
Date: 2004-05-25 03:05:37
Message-ID: 40B2B801.9020201@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jochem van Dieten 2004-05-25 15:37:44 Re: PostgreSQL caching
Previous Message Michael Ryan S. Puncia 2004-05-25 02:54:46 Server process