Closed Bug 803640 Opened 12 years ago Closed 7 years ago

Run VACUUM FREEZE on old partitions on master01

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED WORKSFORME

People

(Reporter: selenamarie, Unassigned)

References

Details

Examining the max_freeze_age on master01 shows that some of our older partitions have large transaction IDs.  

Performing FREEZEs on old tables that never get updated helps reduce the overall amount of vacuuming needed by the database to keep our max transaction id under 1 billion, which in turn reduces read & write load and improves performance overall.

Need to decide: 
* Should this be done when new partitions are created?
* Should we have a separate process take care of this?

Stay tuned...
Blocks: 823507
moved to rds a while ago, moving to simpler schema next
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.