db settings
vlad craciunoiu
vladcrc at yahoo.com
Thu Oct 4 12:22:33 UTC 2012
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fedorahosted.org/pipermail/rhq-devel/attachments/20121004/e6fdf105/attachment.html>
More information about the rhq-devel
mailing list