Re: query timeout

From: Ragnar <gnari(at)hive(dot)is>
To: Rick Gigger <rick(at)alpinenetworking(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: query timeout
Date: 2006-03-03 09:59:00
Message-ID: 1141379940.18656.135.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On fim, 2006-03-02 at 11:03 -0700, Rick Gigger wrote:
> Never-mind that. I'm assuming statement_timeout is what I need?

Yes, but take care if you change this in postgresql.conf:
some queries might reasonaby be expected to take longer
than 5 minutes, such as VACUUM.

gnari

> On Mar 2, 2006, at 11:01 AM, Rick Gigger wrote:
>
> > Is there a way to put a timeout on a query so that if it runs
> > longer than 5 minutes or something it is just automatically
> > terminated?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Mackay 2006-03-03 10:03:24 Physical column size
Previous Message Agnes Bocchino 2006-03-03 09:56:02 Re: How to save and restore a template database ?