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)

Product:
Socorro
Component:
Database
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
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.