We run RHQ 4.4 in our company and our db admin checked the server's activity on the database.
- regular reindex and manual VACUUM runs are not required. There's no reason to run reindex on a every day basis; reindex is flooding the Backup. And there's an autovacuum Daemon since Postgres 8.3.
DELETE FROM RHQ_AVAILABILITY WHERE END_TIME < '1317423602458'; There's an index missing on this column.
- You should check all the join conditions for missing indexes too.
What do you think about it ?
Best regards,
Vlad Craciunoiu - 1&1 Internet AG