Re: setting query timeout as part of the query - Mailing list pgsql-novice

From William Morgan
Subject Re: setting query timeout as part of the query
Date
Msg-id CAPE5=AJ=VjPrRjC+XKiX4fU8DPGk87borwmXXp3S2-7=5OfAqw@mail.gmail.com
Whole thread Raw
In response to Re: setting query timeout as part of the query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Tue, Sep 30, 2014 at 2:39 PM, Tom Lane <tgl@sss.pgh.pa.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
 

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: setting query timeout as part of the query
Next
From: Merlin Moncure
Date:
Subject: Re: setting query timeout as part of the query