[Spacewalk-list] PostgreSQL performance problems

[Morten Middelthon]

> On 08 Dec 2015, at 11:01, Morten Middelthon <mm at lastfriday.com> wrote:
> 
> Hi list,
> 
> we are having serious performance problems with our PostgreSQL database on our spacewalk-installation. The spacewalk server was at first very responsive, but as we’ve added clients, packages and errata is has become more and more sluggish.
> F.ex entering the errata page slows the server considerably down and usually ends up in a timeout. At the same time I can see a postmaster postgres process running with high CPU usage. As a part of this I have turned on logging of slow queries. F.ex:
<snip>

Perhaps also worth mentioning that we’re running an updated 2.4 spacewalk installation

Morten