Please read this previous article, To Understand the Power of BRIN – Block Range Index. Database Theory: What is BRIN (Block Range Index), How is faster than BTREE Index PostgreSQL 9.5 introduced the powerful BRIN Index, which is performance much faster than the regular BTREE Index. The most important two lines of the BRIN are: … Continue reading PostgreSQL 9.5: Introduced BRIN – Block Range Index with Performance Report