![arangodb sharding arangodb sharding](https://image.slidesharecdn.com/scalingmongodbdenganreplicasetdansharding-130720102530-phpapp02/95/scaling-mongo-db-dengan-replicaset-dan-sharding-16-638.jpg)
Sharding in PostgreSQLīy now you might be reasonably questioning my premise, and that partitioning is not sharding, at least not in the sense and context you would have expected this post to cover. These are just a few of the features that led to a more mature partitioning solution.
![arangodb sharding arangodb sharding](https://ik.imagekit.io/ably/ghost/prod/2021/02/fault-tolerance-of-a-stateful-datastore.png)
Fast forward another year and PostgreSQL 11 builds on top of this, delivering additional features like:
![arangodb sharding arangodb sharding](https://www.arangodb.com/wp-content/uploads/2017/07/GraphQuery1Random.png)
Arangodb sharding update#
It wasn’t possible, for example, to perform an UPDATE that would result in moving a row from one partition to a different one, but the foundation had been laid. It still missed the greater optimization and flexibility needed to consider it a complete partitioning solution. Tables defined as partitions of the main table with declarative partitioning, there was no need for triggers anymore. Here’s an example: Using table inheritanceĬREATE TABLE temperature_201903 PARTITION OF temperature FOR VALUES FROM ( '' ) TO ( '' ) įigure 2b. That, combined with the employment of proper constraints in each child table along with the right set of triggers in the parent table, has provided practical “table partitioning” in PostgreSQL for years (and still works). There’s a table inheritance feature in PostgreSQL that allows the creation of child tables with the same structure as a parent table. Not that that prevented people from doing it anyway: the PostgreSQL community is very creative. In a nutshell, until not long ago there wasn’t a dedicated, native feature in PostgreSQL for table partitioning. Please note I haven’t included any third-party extensions that provide sharding for PostgreSQL in my discussion below. I’ve tried to summarize the main points in this post, as well as providing an introductory overview of sharding itself. A couple of weeks ago I presented at Percona University São Paulo about the new features in PostgreSQL that allow the deployment of simple shards.