Re: autovacuum and temporary tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum and temporary tables
Дата
Msg-id 17345.1137770591@sss.pgh.pa.us
обсуждение исходный текст
Ответ на autovacuum and temporary tables  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> writes:
> I have a postgres 8.0 installation, and I'm running autovacuum against
> it. I have noticed that it processes temporary tables too, which is in
> itself a bit curious, but the problem is that autovacuum might even
> crash if a temporary table is suddenly gone while it tries to vacuum
> it... that's what happened once here.

8.0.what?  I'm wondering if you are missing this 8.0.5 fix:

2005-10-20 12:14  tgl

    * contrib/pg_autovacuum/pg_autovacuum.c (REL8_0_STABLE): Prevent
    core dump in contrib version of autovacuum when a table has been
    dropped.  Per report from daveg (not his patch, though).

            regards, tom lane

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

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: autovacuum and temporary tables
Следующее
От: Keary Suska
Дата:
Сообщение: Re: How to fetch rows with multiple values