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.
Cliff -------- Original Message -------- Subject: Re: [Spacewalk-list] Optimizing postgresql with Spacewalk 1.5 on CentOS 6.0 x86_64 Date: Fri, 23 Sep 2011 10:57:13 +0200 From: Michael Mraka <michael.mr...@redhat.com> Reply-To: spacewalk-l...@redhat.com To: spacewalk-l...@redhat.com Gerald wrote: % Hi, % % I'm now syncing for TWO AND A HALF WEEK (spacewalk-repo-sync for centos5+6 % repos) % and still not finished (spacewalk 1.5 with postgresql, centos5 x86_64). % % Especially the larger repos from rpmforge are a massive problem. % With oracle guess I synced all in max. 2 days. % % I've tried the performance settings from below, tried others, added more % ram, etc. but it still takes ages % % (at the moment I'm syncing package 6200 of 8215 and it takes 61sec per % package! In the beginning it's a bit faster and then % it gets slower and slower). % % Disabling taskomatic and osa-dispatcher didn't help either. Maybe there are % some other suggestions to try? % % Hope someone can speed up this process. Don't postgresql restart help you? http://www.redhat.com/archives/spacewalk-list/2011-September/msg00041.html Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list spacewalk-l...@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel