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