W dniu 25 maja 2009 17:50 użytkownik Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> napisał: >> So, in 2000 databases, there's only an average of 2 relations per db >> and 102 dead rows? Cause that's all you got room for with those >> settings. >> >> Whats the last 20 or so lines of vacuum verbose as run by a superuser say? > > according to http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.html > max_fsm_relations applies only to tables and indices, and it says "in > database", so I presume that means per database. In which case, those > settings are ok. > It would be nice, to see if vacuum actually complains about it. Vacuum did complain about that but still got: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 609 postgres 15 0 537m 105m 676 S 21.5 1.4 1:15.00 postgres: autovacuum launcher process 610 postgres 15 0 241m 88m 500 S 20.5 1.1 1:50.87 postgres: stats collector process That autovacuum working hole time, shoudn't be run only when db needs ? -- Ł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
