DBMS > openGauss vs. PostgreSQL vs. TiDB
System Properties Comparison openGauss vs. PostgreSQL vs. TiDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||openGauss Xexclude from comparison||PostgreSQL Xexclude from comparison||TiDB Xexclude from comparison|
|Description||An enterprise-class RDBMS compatible with high-performance, high-availability and high-performance originally developed by Huawei||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||TiDB is an open source distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability.|
|Primary database model||Relational DBMS||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Relational DBMS|
|Secondary database models||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Developer||Huawei and openGauss community||PostgreSQL Global Development Group www.postgresql.org/developer||PingCAP, Inc.|
|Initial release||2019||1989 1989: Postgres, 1996: PostgreSQL||2016|
|Current release||3.0, March 2022||16.1, November 2023||7.4.0, October 2023|
|License Commercial or Open Source||Open Source||Open Source BSD||Open Source Apache 2.0|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.||TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.|
|Implementation language||C, C++, Java||C||Go, Rust|
|Server operating systems||Linux||FreeBSD|
|Typing predefined data types such as float or date||yes||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||yes specific XML-type available, but no XML query functionality.||no|
|SQL Support of SQL||ANSI SQL 2011||yes standard with numerous extensions||yes|
|APIs and other access methods||JDBC|
native C library
streaming API for large objects
|Supported programming languages||C|
|Server-side scripts Stored procedures||yes||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||no|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning (by range, list and hash)||partitioning by range, list and (since PostgreSQL 11) by hash||horizontal partitioning (by key range)|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication||Source-replica replication other methods possible by using 3rd party extensions||Using Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||yes with TiSpark Connector|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||yes full support since version 6.6|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||no||no|
|User concepts Access control||Access rights for users, groups and roles according to SQL-standard||fine grained access rights according to SQL-standard||Fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||TiDB is an advanced open-source, distributed SQL database for modern application...|
|Competitive advantages||- HORIZONTAL SCALING : TiDB grants total transparency into your data workloads without...|
|Typical application scenarios||TiDB is ideal for transactional applications that require extreme scalability and...|
|Key customers||Block, Pinterest, Catalyst, Bolt, Flipkart, Capcom, Shopee (E-commerce), JD Cloud...|
|Market metrics||34K+ GitHub stars 5K+ members in TiDB Community Slack 1K+ community contributors...|
|Licensing and pricing models||TiDB Community : Free open source software (Apache 2.0) TiDB Self-Hosted : Enterprise...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.|
pgDash: In-Depth PostgreSQL Monitoring.
Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
Redgate webinars: A series of key topics for new PostgreSQL users.
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
Instaclustr: Fully Hosted & Managed PostgreSQL
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
|Recent citations in the news|
The openGauss powers database industry forward through innovation
About HUAWEI Open Source
provided by Google News
Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL ...
Timescale Introduces Dynamic PostgreSQL, an Alternative to ...
PostgreSQL Takes a New Turn
Google AlloyDB Omni: PostgreSQL-Compatible Database for On ...
Timescale's Dynamic PostgreSQL Makes Data Provisioning Elastic
provided by Google News
PingCAP Receives Two 2023 AWS Partner of the Year Awards
PingCAP Positioned as a Leader in the 2023 SPARK Matrix for ...
Unlock growth potential with the latest insights on Gen-AI | e27
Announcing TiDB 7.4: The Best Database Alternative for MySQL 8.0
PingCAP Unveils TiDB 7.1, the Latest Advancement In Open Source ...
provided by Google News
Sr PostgreSQL DBA
Full Stack Developer
SSBN/SSGN Missile Technician
Manager, Product Marketing - Customer Data Platform
Professional Services Engineer
Principal Product Manager
Share this page