pg startwithpg

Guides

Install the moving part you already have.

Short, practical setup notes for the Postgres-first stack: queues, vectors, JSONB, cron, and more.

JSONB Use JSONB without giving up relational shape

Store flexible fields in JSONB while keeping important columns, indexes, and constraints normal.

 pgmq Set up a durable queue with pgmq

Create a Postgres-backed queue for small jobs, retries, and simple event handoff.

 pgvector Add semantic search with pgvector

Store embeddings beside source records so search can use normal filters and permissions.

 PostGIS Run nearby search with PostGIS

Use geography points and GiST indexes for practical nearby search inside Postgres.