[
http://opencast.jira.com/browse/MH-8462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=28991#comment-28991
]
Ruediger Rolf commented on MH-8462:
-----------------------------------
I would say that a noSQL database would be a much better solution for the
capture_agent_state table, as this is a simple key-value relation with a quite
large value.
But nevertheless: I enabled autovacuum yesterday (I guess it was enabled before
too, according to the docs. But now I made it explicit in the config file) I
don't know hoe this will be triggered but the table got quite large again over
night. VACUUM only seems to work sometimes (1/10th of my tests) VACUUM ANALYSE
did not work better. VACUUM FULL did a good job:
matterhorn=> SELECT
pg_size_pretty(pg_total_relation_size('capture_agent_state'));
pg_size_pretty
----------------
18 MB
(1 row)
matterhorn=> VACUUM capture_agent_state ;
VACUUM
matterhorn=> SELECT
pg_size_pretty(pg_total_relation_size('capture_agent_state'));
pg_size_pretty
----------------
18 MB
(1 row)
matterhorn=> VACUUM ANALYZE capture_agent_state ;
VACUUM
matterhorn=> SELECT
pg_size_pretty(pg_total_relation_size('capture_agent_state'));
pg_size_pretty
----------------
18 MB
(1 row)
matterhorn=> VACUUM FULL capture_agent_state ;
VACUUM
matterhorn=> SELECT
pg_size_pretty(pg_total_relation_size('capture_agent_state'));
pg_size_pretty
----------------
48 kB
(1 row)
I have no idea if there is a chance that we can improve the tables for this. We
have about 30MB per CA a day. In a 10 CA setup this would mean 300MB a day =
2,1GB a week. So an admin would have to clean up the database at least 3 times
a week.
Has somebody checked if MySQL acts similar?
> capture_agent_state table gets extremly big in postgresql
> ---------------------------------------------------------
>
> Key: MH-8462
> URL: http://opencast.jira.com/browse/MH-8462
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Architecture & Services
> Affects Versions: 1.3
> Reporter: Ruediger Rolf
> Assignee: Denis Meyer
> Priority: Release Blocker
> Fix For: 1.3
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________
