Closed Bug 884348 Opened 11 years ago Closed 11 years ago

Production tweak for v51 release for new 'tcbs' table column

Categories

(Socorro :: Database, task)

x86_64
Linux
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

References

Details

Need to create the column and add the DEFAULT constraint, and remove the 'not null' constraint.  The TCBS table is 2GB in size even after a VACUUM. (contains report data back to 2011)

This changes makes it possible to execute the schema migration in a reasonable amount of time.
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/e9b81c6cadcc982e3862d7af3bb1a998f31d55ff
bug 884348 Make is_gc_count column add fast

https://github.com/mozilla/socorro/commit/becd000fe38bff7db6ec3818a9b969f53cb4ab8c
Merge pull request #1301 from selenamarie/bug884348-migration-speedup

bug 884348 Make is_gc_count column add fast
Depends on: 884957
Assignee: nobody → sdeckelmann
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Summary: Production tweak for v52 release for new 'tcbs' table column → Production tweak for v51 release for new 'tcbs' table column
Target Milestone: --- → 51
You need to log in before you can comment on or make changes to this bug.