Re: PG10.1 autovac killed building extended stats

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PG10.1 autovac killed building extended stats
Date: 2017-11-29 03:05:50
Message-ID: 20171129030550.d3pe2cmkblyj2zvx@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Justin Pryzby wrote:
> On Fri, Nov 17, 2017 at 03:43:52PM -0600, Justin Pryzby wrote:
> > On Fri, Nov 17, 2017 at 01:36:00PM -0300, Alvaro Herrera wrote:

> > > If I recall things correctly, the "continue" should be executed
> > > regardless of IsAutoVacuumWorkerProcess() (only the log should be
> > > conditional on that). I'm not sure how I arrived at the current coding,
> > > which I added in bf2a691e02d7 -- probably just fuzzy thinking.
> >
> > Is it useful to run with that change ?
>
> FYI: the affected server ran without crashing since Nov 18 with this change.

Many thanks for patching and verifying that it works. I pushed the fix
now.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2017-11-29 03:20:39 Re: Code cleanup patch submission for extended_stats.c
Previous Message Michael Paquier 2017-11-29 02:29:36 Re: [HACKERS] [PATCH] Lockable views