[Spacewalk-list] PostgreSQL performance problems

[Silvio Moioli]

On 08/12/2015 11:01, Morten Middelthon wrote:
> we are having serious performance problems with our PostgreSQL database on our spacewalk-installation. [...]PostgreSQL performance problemsl

Could you please share the results of the following queries:

EXPLAIN ANALYZE SELECT E.id, E.update_date, E.synopsis AS ADVISORY_SYNOPSIS
   FROM rhnErrata E,
        (SELECT SNEC.errata_id
           FROM rhnServerNeededCache SNEC
          WHERE SNEC.server_id IN (SELECT server_id FROM rhnUserServerPerms USP WHERE USP.user_id = 13)
            AND errata_id IS NOT NULL
         GROUP BY SNEC.errata_id) X
  WHERE E.id = X.errata_id
ORDER BY  E.update_date DESC, E.id

SELECT relname, relkind, reltuples, relpages FROM pg_class WHERE relname LIKE 'rhn%' ORDER BY relname;

SELECT COUNT(*) FROM rhnErrata;
SELECT COUNT(*) FROM rhnServerNeededCache;
SELECT COUNT(*) FROM rhnUserServerPerms;

As the output might be verbose, please use pastebin or a similar service!

Regards,
-- 
Silvio Moioli
SUSE Manager Development Team