Re: PROC_VACUUM_FOR_WRAPAROUND doesn't work expectedly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PROC_VACUUM_FOR_WRAPAROUND doesn't work expectedly
Дата
Msg-id 12281.1205542421@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PROC_VACUUM_FOR_WRAPAROUND doesn't work expectedly  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane escribi�:
>> The other problem with it is that it's running vacuum() in an
>> indefinite-lifespan context.  Perhaps that has something to do with
>> the report we saw awhile back of autovac leaking memory ...

> Hmm, I'm not sure which memory leak are you referring to, but if it's
> the same I'm thinking of, then it cannot be the same because this one
> occurs on the worker and the other was on the launcher; also, I patched
> that one:

I was thinking of Erik Jones' report of TopMemoryContext bloat in a
database with 200000 tables (in pre-8.3 code).  But I guess this still
doesn't fit, because any leakage induced by vacuum() would have been in
AutovacMemCxt, and that wasn't what he saw.  So I still don't know what
was happening with Erik's issue.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: PROC_VACUUM_FOR_WRAPAROUND doesn't work expectedly
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Autovacuum vs statement_timeout