<a href="http:&#x2F;&#x2F;pythonsweetness.tumblr.com&#x2F;post&#x2F;119568339102&#x2F;block-range-brin-indexes-in-postgresql-95" rel="nofollow">http:&#x2F;&#x2F;pythonsweetness.tumblr.com&#x2F;post&#x2F;119568339102&#x2F;block-ra...</a><p>the very first example points to BRIN indexes resulting in smaller index than btree but with much longer search time... so i guess the 5% time figure was very use-case specific?