Re: setting query timeout as part of the query

Поиск
Список
Период
Сортировка
От William Morgan
Тема Re: setting query timeout as part of the query
Дата
Msg-id CAPE5=AJ=VjPrRjC+XKiX4fU8DPGk87borwmXXp3S2-7=5OfAqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: setting query timeout as part of the query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: setting query timeout as part of the query
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: setting query timeout as part of the query