PostgreSQL 19 ships property graphs: query relationships on existing tables without joins
arpit_bhayani · x · 2026-09-09
PostgreSQL 19 has shipped first-class property graph support. You can define a graph over existing relational tables (users as vertices, follows as edges) and query it with pattern-matching syntax instead of chained joins — no extensions or migrations needed. The graph is a read-only view, and graph queries can be mixed with regular SQL in one statement. Fits social graphs, fraud detection, data lineage, and dependency graphs. Not as performant as dedicated graph databases yet, but a solid choice for 0-to-1 projects. As ever: just use Postgres.
More from Infra
- BeaconKV compresses KV cache for long reasoning models via beacon queries — Janghyeon Kim · 2026-09-09
- The 4 things you need to run local AI: models, Hugging Face, runners, and quantization — Roger_M_Taylor · 2026-09-09
- Google says AI servers pay back in under 2 years, just 1 year on its own silicon — SumitGup · 2026-09-09
- Together claims GLM-5.3 Flash beats Claude Fable 5.1 on agentic tasks at ~1% cost — togethercompute · 2026-09-09
- MCP tool failures hide in HTTP 200, agent retries 6 times billed with no error traces — Thirumalaiboobathi · 2026-09-09
- MCP Creator: AI Is Now in a High-Compute Regime, Adjust Your Plans — hrishioa · 2026-09-09