Re: Problems with autovacuum

W dniu 25 maja 2009 17:50 użytkownik Grzegorz Jaśkiewicz
<gryzman(at)gmail(dot)com> 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