Two out of three LinkBench indexes are made ~40% smaller with traditional B-Trees after an initial bulk load once this optimization is available: youtu.be/p5RaATILoiE?t=. Were you aware of that? (Only with hacked Postgres that loosens the heuristic.)
Conversation
Replying to
That is good news and I am happy Linkbench is useful. PR are welcome github.com/mdcallag/linkb.
What is the impact on size after a few hours of transactions?
2
Replying to
Haven't tried that, but the effect with TPC-C was robust. Space utilization for affected indexes (all the biggest ones) was only a bit shy of 90% after hours/days. (Again, the heuristics added via git.postgresql.org/gitweb/?p=post are too conservative for LinkBench indexes.)
1