Am 23.09.2011 15:49, schrieb Cliff Perry:
So, do we have enough postgreSQL DBA skills to understand what is going
on. Maybe recommend some form of auto vacuum ? or other things for
postgreSQL usage.
I don't know wether I do have enough understanding. However, I found the
import bottleneck and know that you really *need* autovacuum enabled and
have to fix the dangling transactions (see #705935) so autovacuum starts
to improve the situation.
For what you want when you import lots of stuff is
- cancel your import
- stop spacewalk
- run a full vacuum on your spacewalk database
- start spacewalk
- continue your import
The import itself leaks dead rows in rhnchannelnewestpackage because the
dangling transactions make it impossible for vaccuum to reclaim the dead
rows and those are created by every call to
rhn_channel.refresh_newest_package
Regards,
Andreas
--
Solvention Ltd. & Co. KG
Egermannstr. 6-8
53359 Rheinbach
Tel: +49 2226 158179-0
Fax: +49 2226 158179-9
http://www.solvention.de
mailto:i...@solvention.de
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
