Remix.run Logo
Remix clone Hacker News
new | show | ask | jobsGithub
▲ out_of_protocol a day ago

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)

▲maxmcd a day ago | parent [-]

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

▲tandr a day ago | parent [-]

Index Size

    Biscuit 277.09 MB
    Trigram 86 MB
    B-Tree  43 MB
Pretty much you exchange space for speed