Since few years, postgreSQL received several enhancements to process high volumes databases.
I started working with Postgres in 2013 at a web hosting provider of educational solutions. Seduced by the features of the engine and the community I joined Dalibo in 2015 to devote full time to PostgreSQL.
Here you will find articles (mostly in French but I try to translate them) about PostgreSQL (but not only 😄). As well as the presentations that I could make during conferences. Feel free to open an issue on github ;)
Since few years, postgreSQL received several enhancements to process high volumes databases.
This post explains how logical replication works. Especially, difference beharvoirs depending of workloads
Introduction of autovacuum and bgwriter charts dedicated to PostgreSQL in Netdata
This post shows how PostgreSQL use statistics and the restrictions with JSONB type
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.