db settings
John Mazzitelli
mazz at redhat.com
Thu Oct 4 13:33:02 UTC 2012
I thought there was an option in Administration>SystemSettings that lets you tell the server not to perform daily DB maintenance (which is that vacuum).
As for indexes, I believe we purposefully chose not to add that index on RHQ_AVAILABILITY to limit the affect on writes. I can't remember the details. We have performed some DB analysis and opted to not put indexes on some tables, but its been a while and I can't remember all that was decided.
You should write up a Bugzilla issue and document the indexs you think we should need to perhaps some data reports like query plans that you've seen. That could help.
----- Original Message -----
>
>
> 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
>
>
> _______________________________________________
> rhq-devel mailing list
> rhq-devel at lists.fedorahosted.org
> https://lists.fedorahosted.org/mailman/listinfo/rhq-devel
>
More information about the rhq-devel
mailing list