Hello,
We run RHQ 4.4 in our company and our db admin checked the server's activity on the database.
He advised the followings:
- 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.
- create missing indexes would help much more The query below is run very often: DELETE FROM RHQ_AVAILABILITY WHERE END_TIME < '1317423602458'; There's an index missing on this column.
Further missing index: rhq_measurement_sched.definition
- 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