-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: Transactions
-
Storage Engines, Storage Engines - Transactions
-
SE Transactions - 2025-06-20, SE Transactions - 2025-07-04
-
5
Related to WT-14646
When precise checkpoints are enabled in WiredTiger, content newer than the stable timestamp (or checkpoint timestamp when a checkpoint is running) cannot be evicted to disk - it needs to be retained in the cache. Currently, when a dirty page with updates newer than the checkpoint timestamp is reconciled, WiredTiger performs update-restore eviction.
This ticket is part of the work to optimise this process by adding a heuristic that avoids evicting pages with updates newer than the checkpoint timestamp as long as there isn't excessive cache pressure. This would prevent unnecessary update-restore eviction operations.
The proposed change will:
- Add logic to the eviction page selection process to check if a page has updates with timestamps newer than:
- The checkpoint timestamp (if a checkpoint is running)
- The stable timestamp (if no checkpoint is running)
- Skip these pages during normal eviction selection when cache pressure is not critical
- Add additional statistics
- is related to
-
WT-14646 Improve eviction selection policy to avoid update-restore evictions
-
- Needs Scheduling
-