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-17 16:27:49
Message-ID: 20171117162749.5dtkv2oc66v4isqz@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2017-11-17 16:36:00 Re: PG10.1 autovac killed building extended stats
Previous Message Vladimir Rusinov 2017-11-17 16:09:12 Re: Treating work_mem as a shared resource (Was: Parallel Hash take II)