=?UTF-8?B?xYF1a2FzeiBKYWdpZcWCxYJv?= <lukasz.jagiello@xxxxxxxxxx> writes: > That autovacuum working hole time, shoudn't be run only when db needs ? With 2000 databases to cycle through, autovac is going to be spending quite a lot of time just finding out whether it needs to do anything. I believe the interpretation of autovacuum_naptime is that it should examine each database that often, ie once a minute by default. So it's got more than 30 databases per second to look through. Maybe it would make more sense to have one database (or at least, many fewer databases) and 2000 schemas within it? If you really want to stick with this layout, you're going to have to increase autovacuum_naptime. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
