---
title: PostgreSQL
slug: postgresql
url: "https://toolweight.com/options/postgresql"
homepage: "https://www.postgresql.org"
categories: sqlite-vs-postgres-vs-mysql
last_verified: 2026-07-01
license: CC-BY-4.0
---

# PostgreSQL

> MVCC relational server with the widest SQL surface and a deep extension ecosystem.

PostgreSQL is a client/server relational database descended from Berkeley POSTGRES, governed by a contributor community rather than a company. Its extension mechanism is the reason it keeps absorbing adjacent categories: PostGIS made it a geospatial database, TimescaleDB a time-series one, and pgvector a vector store. The trade is operational weight, autovacuum, bloat and a process per connection are yours to manage.

## Identity

|  |  |
| --- | --- |
| Name | PostgreSQL |
| Company | PostgreSQL |
| One-liner | MVCC relational server with the widest SQL surface and a deep extension ecosystem. |
| Site | https://www.postgresql.org |
| Docs | https://www.postgresql.org/docs/current/ |
| Repo | https://github.com/postgres/postgres |
| Founded | 1996 |
| Open source | Yes |
| Licence | PostgreSQL Licence |
| Brand | https://toolweight.com/vendors/PostgreSQL |
| Compared in | 1 |

## Where it is compared

### [Database engines](https://toolweight.com/compare/sqlite-vs-postgres-vs-mysql)
| Field | Value | Confidence | Verified | Source | Note |
| --- | --- | --- | --- | --- | --- |
| Embedded or server | Server (client/server) | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/tutorial-arch.html | - |
| Concurrency model | MVCC (heap row versions) | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/mvcc-intro.html | Dead row versions live in the heap until vacuumed, which is why bloat is a Postgres word and not a MySQL one. |
| Write concurrency | Concurrent writers (row-level) | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/explicit-locking.html | - |
| Isolation levels | Read committed, Repeatable read, Serializable | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/transaction-iso.html | READ UNCOMMITTED is accepted but behaves as READ COMMITTED. SERIALIZABLE is true SSI, not lock-based. |
| JSON support | Binary JSONB + indexes | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/datatype-json.html | jsonb with GIN indexes, containment operators and SQL/JSON path queries. The reason most document-store migrations get cancelled. |
| Full-text search | Built-in | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/textsearch.html | tsvector and tsquery with GIN indexes and ranking. Good enough to defer Elasticsearch for a long time; not a replacement for it. |
| Vector search | Extension | Vendor-claimed | 2026-07-01 | https://github.com/pgvector/pgvector | pgvector is the de facto standard: HNSW and IVFFlat indexes, available on essentially every managed Postgres. |
| Type strictness | Static, strict | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/typeconv.html | Refuses implicit lossy casts. This is the source of most complaints from people arriving from MySQL, and most of the data-integrity wins. |
| ALTER TABLE | Minimal | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/sql-altertable.html | Near-complete DDL inside a transaction you can roll back. ALTER TYPE still rewrites the table under ACCESS EXCLUSIVE. |
| Max database size | - | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/limits.html | Docs state no limit on database size. The per-table ceiling is 32 TB at the default 8 kB page size, and that is the practical single-node wall. |
| Replication | Built-in async + synchronous | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/high-availability.html | Physical streaming plus logical replication in core; synchronous_commit gives quorum or remote-apply durability. Automatic failover is still Patroni's job. |
| PITR | ● | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/continuous-archiving.html | Base backup plus archived WAL restores to a timestamp, an LSN or a named restore point. The reference implementation of the idea. |
| Online schema change | ◐ | Inferred | 2026-07-01 | - | Many ALTERs are metadata-only and instant; type changes rewrite under an exclusive lock. Teams reach for pgroll or pg_repack, and always set lock_timeout. |
| Connection model | Process per connection | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/tutorial-arch.html | A backend process per connection. Past a few hundred clients PgBouncer stops being optional, and serverless compute reaches that number fast. |
| Default max conns | 100 | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/runtime-config-connection.html | - |
| Managed options | Neon, Supabase, Amazon RDS, Amazon Aurora, Google Cloud SQL, Azure Database, PlanetScale | Inferred | 2026-07-01 | - | The widest managed market of any engine here, and the reason most teams never actually run Postgres themselves. |
| Ops burden | 4 | Inferred | 2026-07-01 | - | Autovacuum tuning, bloat, transaction-ID wraparound, connection pooling, and major upgrades via pg_upgrade or logical replication. The best engine here is also the most work. |
| Extension ecosystem | 5 | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/docs/current/extend-extensions.html | PostGIS, pgvector, TimescaleDB, pg_cron, pg_stat_statements. Managed hosts each ship a curated subset, which is worth checking before you depend on one. |
| Client libraries | 5 | Inferred | 2026-07-01 | - | - |
| Migration tooling | 5 | Inferred | 2026-07-01 | - | Atlas, Flyway, Liquibase, sqlx, Drizzle and Prisma all treat Postgres as the reference target, plus pgroll and reshape for expand/contract rollouts. |
| GitHub stars | 18,000 | Community-reported | 2026-07-01 | https://github.com/postgres/postgres | Approximate. Official mirror; development happens on the pgsql-hackers mailing list. |
| Positioning | The world's most advanced open source relational database. | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/ | - |
| Licence | PostgreSQL Licence (BSD-style) | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/about/licence/ | - |
| Embed in closed source | ● | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/about/licence/ | Permissive enough to redistribute inside a proprietary product; the engine's shape means almost nobody does. |
| Governance | Community project | Vendor-claimed | 2026-07-01 | https://www.postgresql.org/developer/ | A core team and a contributor community with no owning company, the strongest acquisition-risk story on this page. |
| First release | 1997-01-29 | Community-reported | 2026-07-01 | https://www.postgresql.org/docs/current/history.html | PostgreSQL 6.0. The lineage runs back through Postgres95 to Berkeley POSTGRES in 1986. |

**Verdict.** The strongest engine here on every axis except the one that costs you time. Nothing else combines transactional DDL, this much SQL and pgvector in the same box, and nothing else here needs you to understand autovacuum, bloat and connection pooling before the first incident.

## Alternatives

- [DuckDB](https://toolweight.com/options/duckdb), In-process columnar analytics engine, SQLite's shape, a warehouse's execution model.
- [MariaDB](https://toolweight.com/options/mariadb), GPL-only MySQL fork under a foundation, with Galera clustering and native vectors.
- [MySQL](https://toolweight.com/options/mysql), The relational server that ran the early web, now Oracle-stewarded and InnoDB-based.
- [SQLite](https://toolweight.com/options/sqlite), Embedded SQL engine that runs inside your process, a file, not a server.

## Licence and attribution

Data from toolweight (https://toolweight.com), licensed CC-BY-4.0.

- Licence: [CC-BY-4.0](https://creativecommons.org/licenses/by/4.0/)
- Canonical HTML: https://toolweight.com/options/postgresql
- Machine-readable: https://toolweight.com/options/postgresql.md · https://toolweight.com/api/v1 · https://toolweight.com/mcp
- toolweight takes no affiliate revenue and sells no placements. Corrections: https://toolweight.com/suggest