1. What Is Postgres Pro Shardman? #
Postgres Pro Shardman is based on the Postgres Pro Enterprise and is an object-relational distributed database management system (ORDBMS), developed by Postgres Professional in the Postgres Pro Shardman fork of PostgreSQL, which is in turn based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.
The database size in modern enterprises and in highload web applications is constantly growing. The working approach to accommodate this growth is horizontal scaling. The Postgres Pro Shardman distributed DBMS is intended to enable horizontal scaling of online transaction processing (OLTP) databases while preserving the strong ACID semantics.
Postgres Pro Shardman runs on the following operating systems:
Ubuntu 20.04/22.04
Debian 10/11/12
Red Hat Enterprise Linux 7/8/9
Red OS 7.3/8
Alt 9/10/10SP
Astra Linux 1.7/1.8/s390
Both PostgreSQL and Postgres Pro Shardman support a large part of the SQL standard and offer many modern features:
Besides, PostgreSQL and Postgres Pro Shardman can be extended by the user in many ways, for example by adding new
Postgres Pro Shardman also provides the following advantages, compatibility features to your applications:
Strong ACID guarantees.
Compatibility with Postgres Pro Enterprise.
Several clusters support within a distributed cluster.
Transparent horizontal scaling without a need in adopting NoSQL DBMS.
Built-in support of replication with no single point of failure, with any node being able to become coordinator that requires no system shut down and prevents any data loss.
Capacity of up to 100 cluster nodes.
High availability with primary and stand-by modes, along with the synchronous solution for the failover scenarios.
Support of planning and execution statistics of all SQL statements.
Utility to discover most resource-intensive activities in your database.
Tools to support
REPEATABLE READisolation level in a distributed system, along with advisory locks.Work with cluster as with a fully functional DBMS.
Backup and recovery tools that support full and incremental backup with logs.
Point-in-time recovery (PITR) as a consistent syncpoint.
High-availability cluster creation with multiple primary nodes with special utilities.
ANSI standard.
Big data storing and processing.
Interfaces for C++, Ruby, C, ODBC, Perl, Python, Tcl, and Java.
EUC, UTF-8, and Mule character set.
Access data stored in external PostgreSQL servers with postgres_fdw.
Long queries monitoring with the pg_query_state module.
No limits for the number of records or indexes, with the maximum table size of 32 TB, maximum attribute size of 1 GB, and maximum number of attributes of 1600.
Detailed access management with different access levels and roles.