Re: PG10.1 autovac killed building extended stats - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: PG10.1 autovac killed building extended stats
Date
Msg-id 20171129030550.d3pe2cmkblyj2zvx@alvherre.pgsql
Whole thread Raw
In response to Re: PG10.1 autovac killed building extended stats  (Justin Pryzby <pryzby@telsasoft.com>)
List 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


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] [PATCH] Lockable views
Next
From: Alvaro Herrera
Date:
Subject: Re: Code cleanup patch submission for extended_stats.c