Postgres Pro
Downloads
Home   >   mailing lists

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 20171117162749.5dtkv2oc66v4isqz@alvherre.pgsql
Whole thread Raw
In response to PG10.1 autovac killed building extended stats  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: PG10.1 autovac crashed building extended stats
List pgsql-hackers
Tree view 
Justin Pryzby wrote:
> After adding extended/MV stats to a few of our tables a few days ago, it looks
> like I wasn't been paying attention and this first crashed 2 nights ago.  Why
> at 1am?  not sure.  I have an "reindex" job which runs at 1am, and an
> vacuum/analyze job which runs at 2am, but I don't use cron to change
> autovac/analyze thresholds..

Can you please show the definition of the table and of the extended
stats?

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

pgsql-hackers by date:

Previous
From: Vladimir Rusinov
Date:
Subject: Re: Treating work_mem as a shared resource (Was: Parallel Hash take II)
Next
From: Alvaro Herrera
Date:
Subject: Re: PG10.1 autovac killed building extended stats