The gmf table is taking a lot of disk space without need

Bug #1170632 reported by Michele Simionato
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenQuake Engine
Fix Released
High
Michele Simionato

Bug Description

At the moment the gmf_agg table is populated from the table gmf for each event based calculation: however the table gmf is never emptied. This means that we are storing twice the space which is needed. This is clearly an issue because the event based calculator in generating large amounts of data and we need to fix it. The problem is that we must make sure that everything in the code
(and in the tests) must access the gmf_agg table and not the old gmf table, which must become only a temporary storage. In the future one may also investigate strategies to remove the gmf table completely.

This ticket can be implemented only after the export procedure and the dump/restore procedure are updated to use the gmf_agg table and not the gmf_table

P.S. Implemented in https://github.com/gem/oq-engine/pull/1182

Changed in oq-engine:
importance: Undecided → High
Changed in oq-engine:
assignee: nobody → Michele Simionato (michele-simionato)
status: New → In Progress
Changed in oq-engine:
milestone: none → 1.0.0
description: updated
Changed in oq-engine:
status: In Progress → Fix Committed
Changed in oq-engine:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.