Giuseppe Broccolo and Julien Rouhaud
Giuseppe Broccolo and Julien Rouhaud
2ndQuadrant and Dalibo

June 29, 2016

English Track - Day 2

Starts at 11:15 am – BRIN Index for PostGis – Solari Room

  45 minutes
  intermediate

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.