On Fri, Sep 15, 2017 at 06:49:06AM -0500, Ron Johnson wrote: > 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.) Not that I know, but it wouldn't help me, since our script also calls pg_repack (for indices on system and some other tables), and also has logic to handle differently historic partition tables. Justin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
