[Spacewalk-list] Postgres spacewalk

[Gerald]

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-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von John Hodrien
Gesendet: Mittwoch, 02. November 2011 16:10
An: spacewalk-list at 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 at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list