Re: [ADMIN] Repeating autovacuum
| От | David G. Johnston |
|---|---|
| Тема | Re: [ADMIN] Repeating autovacuum |
| Дата | |
| Msg-id | CAKFQuwZQ0jC2qrci7Q5HSNEH2qGH4DrzuNd143a1dwG=bGWWJw@mail.gmail.com обсуждение исходный текст |
| Ответ на | [ADMIN] Repeating autovacuum (Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>) |
| Ответы |
Re: [ADMIN] Repeating autovacuum
Re: [ADMIN] Repeating autovacuum |
| Список | pgsql-admin |
No autovacuum parameters are changed or used. They are all remarked as in
default config file.
I wonder if that is a normal behavior as system is idle.
See "autovacuum_naptime (integer)"
Its "auto" vacuum which means it runs (nearly) continuously looking for things to do.
I suppose that in theory it could operate in a kind of "wait/notify" mode where every DDL against the database wakes the daemon otherwise it stays asleep. I recall some work being done a number of years back on making the system more energy efficient during no-activity periods - but there are trade-offs to consider here for which I am not up-to-speed on the specifics.
It would be interesting to see the timestamps on those log entries...
David J.
В списке pgsql-admin по дате отправления: