Closed
Bug 725482
Opened 14 years ago
Closed 9 years ago
Refactor Backfill Matviews script to make it more maintainable
Categories
(Socorro :: Database, task)
Tracking
(Not tracked)
RESOLVED
WONTFIX
Future
People
(Reporter: jberkus, Unassigned)
Details
Currently the backfill_matviews() function is a linear SQL script which is simply extended each time we add a new matview which needs to be backfilled. This worked fine when we had 4 matviews, but has become unsustainable.
I am currently working on making a table-driven version of backfill_matviews which will rely on a table of matviews to be updated, a python script and a PostgreSQL function. This will be maintainable by simply adding a new matview definition to the matviews table each time you create one.
|
Reporter | |
Comment 2•14 years ago
|
||
Bumping to 2.5.2, since it's not done yet.
Target Milestone: 2.5.1 → 2.5.2
|
|
Reporter | |
Comment 3•14 years ago
|
||
Still not working correctly. Bumped.
Target Milestone: 2.5.2 → 2.5.3
|
|
Reporter | |
Updated•14 years ago
|
Target Milestone: 3 → 4
|
|
Reporter | |
Updated•14 years ago
|
Target Milestone: 4 → 5
|
|
Reporter | |
Updated•14 years ago
|
Target Milestone: 5 → 6
|
||
Updated•14 years ago
|
Target Milestone: 6 → 7
|
|
Reporter | |
Comment 4•14 years ago
|
||
Code not ready to go for version 7. May get postponed in favor of getting a test infrastructure working.
Target Milestone: 7 → 9
|
|
Reporter | |
Updated•14 years ago
|
Target Milestone: 9 → Future
|
|
Reporter | |
Comment 5•14 years ago
|
||
This needs to be done immediately after Mobeta. about 50% complete now.
Target Milestone: Future → 19
|
|
Reporter | |
Comment 6•13 years ago
|
||
Have installed workaround for mobeta. As suck, bumping this to version 21.
Target Milestone: 19 → 21
|
|
Reporter | |
Comment 7•13 years ago
|
||
Bumping to 23 so that I can reassign to Selena
Assignee: josh → sdeckelmann
Target Milestone: 21 → 23
|
|
||
Comment 8•13 years ago
|
||
Josh,
Is there a branch with the unfinished refactored code in it?
Thanks!
|
|
Reporter | |
Comment 9•13 years ago
|
||
No ... it's on jberkus/socorro. I pushed the unfinished code to sql/upgrade/backfill.
|
|
||
Updated•13 years ago
|
Target Milestone: 23 → 24
|
|
||
Updated•13 years ago
|
Target Milestone: 24 → Future
|
|
||
Updated•9 years ago
|
Assignee: sdeckelmann → nobody
|
||
Comment 10•9 years ago
|
||
linear backfill_matviews is sustainable enough for our foreseeable future
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → WONTFIX
You need to log in
before you can comment on or make changes to this bug.
Description
•