Re: "Canceling authentication due to timeout" with idle transaction and reindex

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "Canceling authentication due to timeout" with idle transaction and reindex
Date: 2017-09-15 11:49:06
Message-ID: 5f08454c-f052-eed6-0a7f-93f1d686ba10@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Pryzby 2017-09-15 11:57:49 Re: "Canceling authentication due to timeout" with idle transaction and reindex
Previous Message Francisco Olarte 2017-09-15 11:37:18 Re: Table partition - parent table use