With geographical dataset always growing larger, it is now common to have to handle terabytes of data. With such volumes of data, performances of PostGIS GiST indexes tend to drop as their size grow larger than available RAM. For smaller dataset, they perform well but are big and can take a long time to build.
In this presentation, we will present how BRIN indexes can be used on geographical data. Benchmarks will be presented comparing build time, index sizes and performances in read/write queries of BRIN versus GiST indexes. We will also explain current limitations of BRIN indexes and how we can further improve them.
Here you will find the slides from the talk BRIN Index for PostGis.