Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex - Mailing list pgsql-general

From Ron Johnson
Subject Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex
Date
Msg-id 5f08454c-f052-eed6-0a7f-93f1d686ba10@cox.net
Whole thread Raw
In response to [GENERAL] "Canceling authentication due to timeout" with idle transaction andreindex  (s19n <mailbox@s19n.net>)
Responses Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: [GENERAL] Table partition - parent table use
Next
From: Justin Pryzby
Date:
Subject: Re: [GENERAL] "Canceling authentication due to timeout" with idletransaction and reindex