Re: setting query timeout as part of the query

From: William Morgan <william(at)introhq(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: setting query timeout as part of the query
Date: 2014-09-30 21:58:20
Message-ID: CAPE5=AJ=VjPrRjC+XKiX4fU8DPGk87borwmXXp3S2-7=5OfAqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Sep 30, 2014 at 2:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> It shouldn't be terribly costly. One thing you might consider, if you're
> wrapping the statements in transactions anyway, is to use SET LOCAL whose
> effects won't last beyond the transaction. I don't think this will make
> any notable difference speed-wise, but it just seems a tad cleaner if the
> timeouts don't persist.
>

Makes sense. Thanks again!

-William

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Merlin Moncure 2014-09-30 22:03:26 Re: setting query timeout as part of the query
Previous Message Tom Lane 2014-09-30 21:39:17 Re: setting query timeout as part of the query