Re: pg_class reltuples/relpages not updated by autovacuum/vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_class reltuples/relpages not updated by autovacuum/vacuum
Дата
Msg-id 25017.1306291669@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_class reltuples/relpages not updated by autovacuum/vacuum  (Florian Helmberger <fh@25th-floor.com>)
Ответы Re: pg_class reltuples/relpages not updated by autovacuum/vacuum  (Florian Helmberger <fh@25th-floor.com>)
Список pgsql-admin
Florian Helmberger <fh@25th-floor.com> writes:
> I'm running a production database with PostgreSQL 9.0.3 (64-bit) on
> Debian 5.0.4 and have an issue with a TOAST table and far to frequent
> autovacuum runs.

> I think I've pinned the problem down to the values pg_class holds for
> the affected TOAST table:

> relpages  | 433596
> reltuples | 1868538

> These values are significantly too low. Interestingly, the autovacuum
> logout reports the correct values:

>     pages: 0 removed, 34788136 remain
>     tuples: 932487 removed, 69599038 remain

> but these aren't stored in pg_class after each run.

That's exceedingly weird.  Do the pg_stat_all_tables columns update
after autovacuums on that table?

            regards, tom lane

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Seems like a large amount of xlog files
Следующее
От: Florian Helmberger
Дата:
Сообщение: Re: pg_class reltuples/relpages not updated by autovacuum/vacuum