Since few years, postgreSQL received several enhancements to process high volumes databases.

CONTINUE READING

This post explains how logical replication works. Especially, difference beharvoirs depending of workloads

CONTINUE READING

Introduction of autovacuum and bgwriter charts dedicated to PostgreSQL in Netdata

CONTINUE READING

This post shows how PostgreSQL use statistics and the restrictions with JSONB type

CONTINUE READING

Almost everyone has heard of partitioning and logical replication in PostgreSQL 10. Have you heard about the support of ICU collations (International Components for Unicode)?

This article will present what this new feature is but also the possible gains by exploiting abbreviated keys.

CONTINUE READING

Talks

Full text search is a technique for finding information in a document.

This type of index looks promising for high volumetry where there is a strong correlation between the data and their location.

Events