[PDB-1226] Create GC code for disassociated fact paths/values Created: 2015/02/10 Updated: 2016/04/27 Resolved: 2015/03/30
|Fix Version/s:||PDB 2.3.1|
|Reporter:||Ryan Senior||Assignee:||Rob Browning|
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
|Sprint:||PuppetDB 2015-02-25, PuppetDB 2015-03-11, PuppetDB 2015-03-25, PuppetDB 2015-04-08|
Although we currently remove disassociated fact paths/values "as we go", it's possible, if there are two concurrent transactions that each are pointing to the same fact path and value and they are simultaneously changing to a different value, their original value could be left behind. This process would clean those up. This seems to be pretty rare that it happens, so the number of fact values left behind is pretty low. These extra values don't actually cause problems (with the new table structure created in
Care needs to be taken on the complexity of this query, how often it runs, how many records it would actually delete and the impact to the running system.
|Comment by Rob Browning [ 2015/03/05 ]|
Initial implementation is here currently here: https://github.com/rbrw/puppetdb/tree/ticket/stable/pdb-1226-global-inc-gc
Next we'll need some initial perf analysis/review (i.e.