I'm using spacewalk 1.5/postgres with about 100 hosts. It's horrible slow with postgres compared to oracle, but with oracle I've hit the limits of the free Oracle XE edition so I had to update. I'm not a big oracle fan, but now I'm wishing I had that performance again.
Problems: I hit problems on registering new systems, with osad and importing large repos like rpmforge takes now about a week. It seems that a lot of open transactions (from osa?) are causing performance problems on postgres. Hope that could be improved in the next version. Just my 2 cents, Gerald -----Ursprüngliche Nachricht----- Von: spacewalk-list-boun...@redhat.com [mailto:spacewalk-list-boun...@redhat.com] Im Auftrag von John Hodrien Gesendet: Mittwoch, 02. November 2011 16:10 An: spacewalk-list@redhat.com Betreff: [Spacewalk-list] Postgres spacewalk Are people using spacewalk in a decently large setup and finding the performance passable? I'd previously used SW 1.4 Oracle with about 50 hosts and found it tolerable, but I'm not finding this with 1.4 or 1.5 with Postgres. I installed 1.4 Postgres (later upgraded to 1.5), and the performance is really pretty weak. Nothing in the webui causes problems, but lots of other bits seem to hammer the database. The two setups aren't identical, but if anything the Oracle hardware is weaker. 'rhncfg-client diff' with a very similar set of config files. Oracle 7 seconds Postgres 4m 12 seconds That's just whacko. All the load seems to be on the postgres server (I've split this off from the rest of spacewalk to be sure). Any suggestions as to what might be wrong with this setup? I've even disabled osad because that was bringing everything to a grinding halt. jh _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list