Re: PG10.1 autovac killed building extended stats

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: PG10.1 autovac killed building extended stats
Дата
Msg-id 20171117162749.5dtkv2oc66v4isqz@alvherre.pgsql
обсуждение исходный текст
Ответ на PG10.1 autovac killed building extended stats  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: PG10.1 autovac crashed building extended stats
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Vladimir Rusinov
Дата:
Сообщение: Re: Treating work_mem as a shared resource (Was: Parallel Hash take II)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PG10.1 autovac killed building extended stats