Skip site navigation (1) Skip section navigation (2)

Re: Problems with autovacuum

From: Łukasz Jagiełło <lukasz(dot)jagiello(at)gforces(dot)pl>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Problems with autovacuum
Date: 2009-05-25 18:43:27
Message-ID: de899fb00905251143n7280c922sb3a5e9132d2baf7c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2009-05-25 18:55:06
Subject: Re: Problems with autovacuum
Previous:From: Łukasz JagiełłoDate: 2009-05-25 18:31:38
Subject: Re: Problems with autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group