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.
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 :
Another attended feature is logical replication. I will present it in a serie of articles.
Note: This article was written during my activity at Dalibo
Postgres respects ACID properties, so it guarantees the consistency of the database: a transaction will bring the database from one valid state to another.
The data in the different tables is not independent but obeys semantic rules put in place when designing the conceptual model. The main purpose of integrity constraints is to ensure the consistency of the data between them, and therefore to ensure that they respect these semantic rules. If an insert, an update or a delete violates these rules, the transaction is purely and simply canceled.
Postgres performs constraint verification on each change (when constraints have been defined). It is also possible to delay the checking of the constraints at the end of the transaction, at the time of the commit. Thus, the verifications will only be produced on the effective changes between the delete, update and insert operations of the whole transaction.