# PGX: disposable PostgreSQL databases for agents and tests

Canonical source : [PGX: disposable PostgreSQL databases for agents and tests](<https://sebastien.rigaux.be/en/tech-watch/links/pgx-disposable-postgresql-databases-for-agents-and-tests>)

PGX runs isolated PostgreSQL databases inside a single Rust runtime, targeting short-lived agent, CI, and test environments. On-demand creation from a sealed template and copy-on-write on ZFS reduce the cost of branching; without block cloning, the system makes a full copy.

The project is at **v0.1.0** and targets disposable databases, not production data: `fsync` is disabled, and one runtime is a single failure domain. Its benchmarks document their measurements and conditions; the PostgreSQL regression suite reports zero result differences in the stated configuration, without claiming general compatibility.

- Selected on : 2026-10-22

- Entry updated : 2026-11-07T20:32:37+0000

- Format : Article

- Source language : EN

Original resource : [PGX: disposable PostgreSQL databases for agents and tests](<https://github.com/pgrundev/pgx>)

Tags : [PostgreSQL](<https://sebastien.rigaux.be/en/tech-watch/tags/postgresql>) · [Testing](<https://sebastien.rigaux.be/en/tech-watch/tags/testing>) · [AI Agents](<https://sebastien.rigaux.be/en/tech-watch/tags/ai-agents>) · [CI/CD](<https://sebastien.rigaux.be/en/tech-watch/tags/ci-cd>)

Available versions : [Français](<https://sebastien.rigaux.be/veille/liens/pgx-des-bases-postgresql-ephemeres-pour-agents-et-tests>) · [English](<https://sebastien.rigaux.be/en/tech-watch/links/pgx-disposable-postgresql-databases-for-agents-and-tests>)

[Back to tech watch](<https://sebastien.rigaux.be/en/tech-watch>)