Release date: 2021-10-08
This is the first version of Shardman software released as packages for the following platforms:
rhel-7-amd64
rhel-8-amd64
ubuntu-20.04-amd64
Shardman core is based on PostgreSQL with additional patches. The modifications improve performance and functionality when PostgreSQL is used as a distributed DBMS.
As a consequence, major enhancements affect distributed tables and include:
Support for ACID transactions.
Initial support for global tables.
Fast collection of statistics and support for efficient autovacuum.
Optimize estimation of remote joins and scans.
Network metrics in explain and pg_stat_statements.
Enhancement of FDW push down for function scan and expressions with time functions
Enhancement of partition-wise joins when the partitioning key is specified as a filter.
Optimization of routing short transactions.
Fast COPY FROM.
Shardman extension and management utilities provide:
Distributed DDL.
Ability to add, remove nodes and automatically rebalance data.
Ability to create a fault-tolerant cluster with automatic failover at the shard level.
Multi-threaded data loader.
Transparent cluster-wide access management.
Facilities to backup and restore an entire cluster.
Shardman software also includes third-party components:
stolon-0.16.0.
etcd-3.4.16.