[Spacewalk-devel] V1.2 (nightly) and PG (solved)

Luc de Louw luc at delouw.ch
Sun Nov 21 07:02:03 EST 2010


On 11/21/2010 02:10 AM, Colin Coe wrote:

> - Running spacewalk-repo-sync slows down to a crawl after approx 2000 packages.

Hi Colin,

I found the reason: Autovacuum seems to be off by default in 
/var/lib/pgsql/data/postgresql.conf. I'm not sure if this can be 
considered a bug of the postgresql84 package...

After enabling it, the performance went back to normal and log entries 
such as: "Nov 21 11:58:17 spacewalk-pg postgres[4701]: [2-1] LOG: 
automatic vacuum of table "spaceschema.public.rhnchannelnewestpackage": 
index scans: 1
Nov 21 11:58:17 spacewalk-pg postgres[4701]: [2-2]      pages: 0 
removed, 1858 remain
Nov 21 11:58:17 spacewalk-pg postgres[4701]: [2-3]      tuples: 5610 
removed, 3430 remain
Nov 21 11:58:17 spacewalk-pg postgres[4701]: [2-4]      system usage: 
CPU 0.03s/0.04u sec elapsed 66.45 sec" appeared.

Please have a look at 
http://www.postgresql.org/docs/8.4/static/runtime-config-autovacuum.html 
and change your postgresql.conf accordingly.

Thanks,

Luc




More information about the Spacewalk-devel mailing list