2009/5/25 Tom Lane <tgl@xxxxxxxxxxxxx>: > 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? It's rather impossible in my case. > If you really want to stick with this layout, you're going to have to > increase autovacuum_naptime. Thanks for hint. -- Łukasz Jagiełło System Administrator G-Forces Web Management Polska sp. z o.o. (www.gforces.pl) Ul. Kruczkowskiego 12, 80-288 Gdańsk Spółka wpisana do KRS pod nr 246596 decyzją Sądu Rejonowego Gdańsk-Północ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
