Re: Autovacuum Question - Mailing list pgsql-admin

From Mark Liberman
Subject Re: Autovacuum Question
Date
Msg-id 9D938282F8C6EE43B748B910386DE93E0138B449@srvgpimail1.GPI.local
Whole thread Raw
In response to Autovacuum Question  ("Chris Hoover" <revoohc@gmail.com>)
Responses Re: Autovacuum Question  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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 by date:

Previous
From: "Chris Hoover"
Date:
Subject: Autovacuum Question
Next
From: "Ian Westmacott"
Date:
Subject: Re: Autovacuum Question