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
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
