pg_autovacuum / pg_class
От | Tomas Vondra |
---|---|
Тема | pg_autovacuum / pg_class |
Дата | |
Msg-id | 454097E2.8000205@fuzzy.cz обсуждение исходный текст |
Ответы |
Re: pg_autovacuum / pg_class
|
Список | pgsql-general |
Hello, I have a simple question about auto-vacuuming. We are running a Postgres 8.1 and I've noticed that some of the tables are not analyzed by the pg_autovacuum daemon. That is - when I select the rows from pg_class, all the important values (relpages, reltuples) are 0. I've noticed this in case of newly created tables (that is not older than 1 month). My 'theory' is this - the table has to be analyzed by hand at the beginning, otherwise the pg_autovacuum won't process it. Am I right? We use default values for all pg_autovacuum related parameters in postgresql.conf, and there are no rows in pg_autovacuum. The new tables are growing pretty fast (about 1.000.000 of rows each month), so the thresholds should be exceeded pretty very fast. But maybe this is caused by some stupid misconfiguration and/or is a known feature ... thanks for all your advices Tomas
В списке pgsql-general по дате отправления: