Re: Autoanalyze settings with zero scale factor

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autoanalyze settings with zero scale factor
Дата
Msg-id 6362.1169155817@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Autoanalyze settings with zero scale factor  ("Jeremy Haile" <jhaile@fastmail.fm>)
Ответы Re: Autoanalyze settings with zero scale factor  ("Jeremy Haile" <jhaile@fastmail.fm>)
Список pgsql-performance
"Jeremy Haile" <jhaile@fastmail.fm> writes:
> No tables have been vacuumed or analyzed today.  I had thought that this
> problem was due to my pg_autovacuum changes, but perhaps not.  I
> restarted PostgreSQL (in production - yikes)  About a minute after being
> restarted, the autovac process fired up.

> What could get PG in a state where autovac isn't running?

Um, are you sure it wasn't?  The autovac process is not an always-there
thing, it quits after each pass and then the postmaster starts a new one
awhile later.

            regards, tom lane

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

Предыдущее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Configuration Advice
Следующее
От: Chris Mair
Дата:
Сообщение: Re: [pgsql-advocacy] Postgres and really huge tables