Re: [HACKERS] Autovacuum loose ends

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Autovacuum loose ends
Дата
Msg-id 11698.1122501900@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Autovacuum loose ends  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-patches
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Ok, so there's a reason for having a manual stat-reset.  However what's
> the rationale for cleaning stats at postmaster start?  In fact I think
> it's actively bad because you lose any data you had before postmaster
> stop/crash.

We probably *should* drop the stats file if any WAL replay activity
occurs, because the stats file could be out of sync with reality
--- this is particularly important in a PITR recovery situation,
where the stats file is likely to be WAY out of sync.  (Maybe only
clobber it in PITR mode?)

I agree that the argument for doing it in a normal restart is pretty
weak.

            regards, tom lane

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

Предыдущее
От: "Kevin McArthur"
Дата:
Сообщение: PLPGSQL OID Bug
Следующее
От: "Rocco Altier"
Дата:
Сообщение: AIX - pgport/contrib resolution