This extension can be useful for diagnosing requests with very short execution times.
Impact on performances
When postgres do not use heap-only-tuple updates and introduction to the new feature in v11
How MVCC works and heap-only-tuples updates
Since few years, postgreSQL received several enhancements to process high volumes databases.
This post explains how logical replication works. Especially, difference behaviors 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.
PostgreSQL 10 is coming soon, it is scheduled for tomorrow : See this commit
This release includes expected features :
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.