You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We actually do NOT implement garbage collection literally. However, a compaction mechanism is provided so that user can discard old logs safely.
In the compaction process, we need to care "ancient pages," which are pages located before certain point in the log, but still being referenced from the active snapshot. Compaction can be safely done by making copy of those ancient pages to the log tip, and by redirecting references to them.
This is done by performing a full scan of the table, and making list of ancient pages found during scan.