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:
Releases notes Wiki page about v10 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.
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 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:
BRIN Indexes - Overview BRIN Indexes - Operation BRIN Indexes - Correlation BRIN Indexes - Performances This article is the last of the series, it will be dedicated to performances (maintenance, reading, insertion …)
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:
BRIN Indexes - Overview BRIN Indexes - Operation BRIN Indexes - Correlation BRIN Indexes - Performances I this third article, I will explain why physical correlation is important for BRIN indexes.
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:
BRIN Indexes - Overview BRIN Indexes - Operation BRIN Indexes - Correlation BRIN Indexes - Performances In this second article we will see how BRIN indexes works.
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:
BRIN Indexes - Overview BRIN Indexes - Operation BRIN Indexes - Correlation BRIN Indexes - Performances