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

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