Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex
Дата
Msg-id 5f08454c-f052-eed6-0a7f-93f1d686ba10@cox.net
обсуждение исходный текст
Ответ на [GENERAL] "Canceling authentication due to timeout" with idle transaction andreindex  (s19n <mailbox@s19n.net>)
Ответы Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-general
Дерево обсуждения 
On 09/15/2017 06:34 AM, Justin Pryzby wrote:
[snip]
> But you might consider: 1) looping around tables/indices rather than "REINDEX
> DATABASE", and then setting a statement_timeout=9s for each REINDEX statement;

Is there a way to do that within psql?  (Doing it from bash is trivial, but 
I'd rather do it from SQL.)

-- 
World Peace Through Nuclear Pacification



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: [GENERAL] Table partition - parent table use
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex