new | ask | show | jobs
out_of_protocol 2 days 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 2 days ago  [ - ]

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

tandr a day ago  [ - ]

Index Size

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