Improve fact value write performance by implementing a simple generational GC.
Potential approach:
Add an integer 'generation' column to fact_values
All facts come in at generation zero
Limit pinpoint fact gc only to values in generation zero, with a partial index of fact_values where generation=0.
When doing the first full GC, capture the current set of all fact values with a bloom filter
At subsequent full GCs, compare the set of all fact values with the previous set. If the value was maybe present in the last generation, set it to generation 1. If it definitely wasn't in the last generation, set it to generation 0.
Improve fact value write performance by implementing a simple generational GC.
Potential approach:
* Add an integer 'generation' column to fact_values * All facts come in at generation zero * Limit pinpoint fact gc only to values in generation zero, with a partial index of fact_values where generation=0. * When doing the first full GC, capture the current set of all fact values with a bloom filter * At subsequent full GCs, compare the set of all fact values with the previous set. If the value was maybe present in the last generation, set it to generation 1. If it definitely wasn't in the last generation, set it to generation 0.