On 12/12/19 1:35 PM, Mark Dilger wrote:
Let C = 1.00000002065 Let x = xid_age for a table Let v = clamp(n_dead_tuples / reltuples*2) to max 0.5 Let a = clamp(changes_since_analyze / reltuples) to max 0.5 Let score = C**x + v + a
I should hasten to add that this is just a proof of concept formula, not one that I'm specifically advocating. The point is that we can devise a scoring system in which the xid age is the dominant factor whenever it could possibly matter, while still letting other factors prevail when xid age is of little consequence. -- Mark Dilger
