PostgreSQL vs TiDB Cloud

PostgreSQL is a free, open-source database system for storing and scaling complex data workloads. It uses SQL and adds object-relational capabilities, with support for primitive and structured values as well as documents, geometric data, and custom types. Its supported formats include JSON/JSONB, XML, arrays, ranges, and UUIDs. For data integrity, it provides keys, constraints, locks, transactions, savepoints, and SQL-standard transaction isolation levels. Performance tools include multiple index types, query planning and optimization, parallel processing, partitioning, just-in-time expression compilation, and asynchronous I/O. Recovery and availability features include write-ahead logging, several replication methods, point-in-time recovery, and active standbys. Security options include multiple authentication methods, access controls, row- and column-level security, and multi-factor authentication. Extensions, procedural languages, and foreign data wrappers can connect PostgreSQL to other databases or streams. It runs on Linux, macOS, and Windows, and is self-hosted; no managed service is listed. The PostgreSQL License permits use, copying, modification, and distribution without a fee, subject to its conditions.

TiDB Cloud is a managed cloud database service built around an open-source distributed SQL database with MySQL compatibility. It supports transactional and analytical workloads, horizontal scaling, multi-region deployment, and geo-partitioning across Starter, Essential, Premium, and Dedicated plans. Starter includes up to 25 GiB of row storage, 25 GiB of column storage, and 250 million Request Units per month per organization, for up to the first five instances. Its on-demand compute scales to zero when idle, and vector storage and search are in public preview. CSV, Parquet, and SQL file imports are supported across the listed plans. Email and password login, SSO options, private and public endpoints, and console audit logging are listed across all four plans. Prometheus, Grafana, and Datadog integrations are listed for Essential, Premium, and Dedicated in public preview. All users can submit billing and account support tickets; guaranteed technical-ticket response times require paid support plans. The service is available through web and API platforms. Starter is free; the Dedicated plan is listed as starting at $0.22 a month and from $1376 / month.