Release date: 2022-02-01
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 distributed ACID transactions.
Support for global tables.
Fast collection of statistics and support for efficient autovacuum.
Network metrics in EXPLAIN and pg_stat_statements.
Enhancement of the push down technique for:
ForeignScan and FunctionScan joins
Case expressions
Stable time value functions
Partial aggregates with simple partial functions
Better estimation of remote joins and scans
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.