BRIN

PostgreSQL's developments for high volumes processing
Since few years, postgreSQL received several enhancements to process high volumes databases.
16 Apr 2018 10 min read Postgres
BRIN Indexes – Performances

PostgreSQL 9.5 released in january 2016 brings a new kind of index: BRIN indexes for Bloc Range INdex. They are recommanded when tables are very big and correlated with their physical location. I decided to devote a series of articles on these indexes:

This article is the last of the series, it will be dedicated to performances (maintenance, reading, insertion …)

21 Apr 2016 7 min read Linux, Postgres
BRIN Indexes – Correlation

PostgreSQL 9.5 released in january 2016 brings a new kind of index: BRIN indexes for Bloc Range INdex. They are recommanded when tables are very big and correlated with their physical location. I decided to devote a series of articles on these indexes:

I this third article, I will explain why physical correlation is important for BRIN indexes.

20 Apr 2016 8 min read Linux, Postgres
BRIN Indexes – Operation

PostgreSQL 9.5 released in january 2016 brings a new kind of index: BRIN indexes for Bloc Range INdex. They are recommanded when tables are very big and correlated with their physical location. I decided to devote a series of articles on these indexes:

In this second article we will see how BRIN indexes works.

20 Apr 2016 9 min read Linux, Postgres
BRIN Indexes – Overview

PostgreSQL 9.5 released in january 2016 brings a new kind of index: BRIN indexes for Bloc Range INdex. They are recommanded when tables are very big and correlated with their physical location. I decided to devote a series of articles on these indexes:
19 Apr 2016 2 min read Linux, Postgres