# PostgreSQL

Relational SQL engine with JSON types and extensibility.

## Comparison target

Relational · Self-managed · Engine

Operator manages deployment, backups and upgrades. This target excludes extensions.

Components: No separate catalog component

Revision: 2026-09-14.1 · Review: unreviewed

Commissioned by a Nimbalyst maintainer. Documentation synthesis; no independent review or product execution.

## Applicability

Unpinned upstream documentation accessed 2026-09-14; pin engine, extension and service versions before use.. Operator manages deployment, backups and upgrades. This target excludes extensions..

## Claims

- **yes · documented**: Queries relational tables using SQL. [PostgreSQL overview](https://www.postgresql.org/about/) Scope: Documented for this target; no runtime tests recorded.
- **yes · documented**: Supports JSON and JSONB values. [PostgreSQL overview](https://www.postgresql.org/about/) Scope: Documented for this target; no runtime tests recorded.
- **yes · documented**: Supports transactions and isolation levels including Serializable. [PostgreSQL overview](https://www.postgresql.org/about/) Scope: Documented for this target; no runtime tests recorded.
- **yes · documented**: Supports synchronous, asynchronous and logical replication. [PostgreSQL overview](https://www.postgresql.org/about/) Scope: Documented for this target; no runtime tests recorded.
- **yes · documented**: Supports WAL-based point-in-time recovery. [PostgreSQL overview](https://www.postgresql.org/about/) Scope: Operator must configure recovery and retain the required WAL and backups.

## Open questions

- Which pinned versions, topology and service tier fit the intended workload?
- What are measured correctness, latency, recovery and total operating cost under that workload?

## Verification plan

1. Pin the target configuration and define workload fixtures, access and budget.
2. With authorization, test concurrent writes and recovery against explicit correctness expectations.
3. For vector workloads, measure filtered recall against an exact-search baseline and record index settings.

Last checked: 2026-09-14. Recheck by: 2026-10-14.

Content rights: Unlicensed prototype; redistribution decision pending.