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
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
