logoalt Hacker News

out_of_protocolyesterday at 7:37 PM1 replyview on HN

Any data on index size for big tables? Comparison (with ms/megabytes) vs trigram regarding size/speed?

UPD

> Biscuit is 15.0× faster than B-tree (median) and 5.6× faster than Trigram (median)

> Trade-off: 3.2× larger index than Trigram, but 5.6× faster queries (median)


Replies

maxmcdyesterday at 8:36 PM

I found some more info here: https://biscuit.readthedocs.io/en/latest/benchmark_roaring.h...

show 1 reply