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

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

Recent & Upcoming Talks

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.


PostgreSQL 10 is coming soon, it is scheduled for tomorrow : See this commit

This release includes expected features :

  • Logical replication
  • Native partitioning
  • Better parallelism support
  • Multi-column statistics

For an exhaustive list see:

In this article I will expose you performance improvements that are not listed in the releases notes! Surprisingly, the community does not list these kinds of improvements: they do not represent a significant change from user experience.


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 uses unknown notions from DBA: stemming, vector representation of a document … The tendency to use a dedicated tool for full-text search: ElasticSearch, SOLR … PostgreSQL’s advanced features are not known. However, there are several advantages to use the PostgreSQL FTS:


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.


Next PostgreSQL version is approaching. This version comes with an impressive feature list :

  • Native partionning
  • Sorts and aggregation improvements
  • Better parallelism support : parallel index scan, parallel hash join, parallelism for subquery
  • Extended statistics
  • ICU collation: enable use of “abbreviated keys”, disabled in 9.5.2 due to libc bug. Abbreviated keys brings sort improvements (arround 20-30%). It is usefull when a query need a sort or for index creation.
  • … look at wiki page New in Postgres 10 or releases notes.

Another attended feature is logical replication. I will present it in a serie of articles.