Re: Autovacuum Question

Поиск
Список
Период
Сортировка
От Mark Liberman
Тема Re: Autovacuum Question
Дата
Msg-id 9D938282F8C6EE43B748B910386DE93E0138B449@srvgpimail1.GPI.local
обсуждение исходный текст
Ответ на Autovacuum Question  ("Chris Hoover" <revoohc@gmail.com>)
Ответы Re: Autovacuum Question  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-admin

>Does this mean that each run of autovacuum will vacuum/analyze all tables
>that need work in the database that autovacuum is looking at?

Yes, it will do all tables that satisfy the criteria.

>Also, with over 200 databases, does this mean that a database will only get
>checked once about every 3.5 hours, or does autovacuum run on the database
>that needs the vacuuming the most?

If, you have it set to 60 seconds, then yes.  It hits one db each minute.  Actually, to be more clear, it sleeps 1 minute between each check.  So, if, on average, it takes 60 seconds to perform the necessary vacuum/analyzes, then it there will be, on average, 2 minutes between each db, or 400 minutes to get through all 200 dbs.

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

Предыдущее
От: "Chris Hoover"
Дата:
Сообщение: Autovacuum Question
Следующее
От: "Ian Westmacott"
Дата:
Сообщение: Re: Autovacuum Question