Hello, Has anyone tried to introduce BRIN indexes into the database schema?
BRIN index is a great solution when we have a table in which the data is arranged chronologically by date or sequence number. It provides similar benefits to horizontal partitioning or sharding but without needing to explicitly declare partitions. BRIN-based indexes consume significantly less memory than B-tree indexes. It is supported by PostgreSQL In one project, where I have over 10 million records in one single table, rows looup took over 5 minutes. After introduce BRIN indexes, the time has dropped to less than 0.5 seconds. I personally love it. At first glance, this database structure perfectly matches our use case. Best regards, Kamil Breguła
