PostgreSQL 10 : ICU & Abbreviated Keys
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 …
PostgreSQL 10 : Performances improvements
PostgreSQL 10 is coming soon, it is scheduled for tomorrow : See this commit This release includes expected features : Logical replication Native partitioning Better parallelism …
PGDay : How does Full Text Search works?
During last PGDay I gave a presentation how Full Text Search works in PostgreSQL. This feature is unfortunately not well known. I see several reasons for this: Complexity: The FTS …
PostgreSQL 10 and Logical replication - Setup
This article is the result of a series of articles on logical replication in PostgreSQL 10 This one will focus on the implementation of logical replication.
PostgreSQL 10 and Logical replication - Overview
Next PostgreSQL version is approaching. This version comes with an impressive feature list : Native partionning Sorts and aggregation improvements Better parallelism support : …
PostgreSQL : Deferrable constraints
Differ constraints verification Note: This article was written during my activity at Dalibo Postgres respects ACID properties, so it guarantees the consistency of the database: a …
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 …
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 …
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 …
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 …