[Spacewalk-list] Postgresql slowness

[Silvio.Schanz at elektrobit.com]

I noticed the same behavior after my postgres migration. 
My sync of the fedora channel slowed down. 

I started a repo-sync yesterday at 14:41 and I got only 300 packages
until now (8:00).

Regards,
  Silvio

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of John Hodrien
Sent: Wednesday, July 20, 2011 1:17 PM
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Postgresql slowness

So making some paltry effort to track down the slowness, I thought I'd log the slow queries in postgres (I'm making this up as I go along, I'm no seasoned DBA).

Every package push, I'll get:

LOG:  duration: 2379.433 ms  statement: SELECT rhn_channel.refresh_newest_package(102, E'server.app.yumreposync')

The time this takes seems to increase fairly linearly as more packages get added.

Any tips on either making this faster, or at least understanding why it takes so long?  Does this really need calling every package during a repo-sync?

jh

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list


----------------------------------------------------------------
Please note: This e-mail may contain confidential information
intended solely for the addressee. If you have received this
e-mail in error, please do not disclose it to anyone, notify
the sender promptly, and delete the message from your system.
Thank you.