Forem

# postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Hybrid search with RRF: combining pgvector, tsvector, and a knowledge graph in one query"
Cover image for Hybrid search with RRF: combining pgvector, tsvector, and a knowledge graph in one query"

Hybrid search with RRF: combining pgvector, tsvector, and a knowledge graph in one query"

Comments
9 min read
Audit Logging with Claude Code: Who Changed What and When

Audit Logging with Claude Code: Who Changed What and When

Comments
3 min read
Multi-tenant SaaS with Claude Code: Tenant Isolation and Row Level Security

Multi-tenant SaaS with Claude Code: Tenant Isolation and Row Level Security

Comments
3 min read
Full-Text Search with Claude Code: MeiliSearch and PostgreSQL tsvector

Full-Text Search with Claude Code: MeiliSearch and PostgreSQL tsvector

Comments
3 min read
16GB of RAM, 12GB of JSON, and One Very Loud Fan

16GB of RAM, 12GB of JSON, and One Very Loud Fan

Comments
5 min read
SQL Indexes Explained: Write Queries That Don't Make Your Database Cry

SQL Indexes Explained: Write Queries That Don't Make Your Database Cry

Comments
6 min read
Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted
Cover image for Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted

Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted

1
Comments
14 min read
pg-stress — Stress Testing PostgreSQL with Claude-powered advisory
Cover image for pg-stress — Stress Testing PostgreSQL with Claude-powered advisory

pg-stress — Stress Testing PostgreSQL with Claude-powered advisory

Comments
2 min read
PostgreSQL Query Performance: The Complete EXPLAIN ANALYZE Guide for Developers Who've Had Enough

PostgreSQL Query Performance: The Complete EXPLAIN ANALYZE Guide for Developers Who've Had Enough

Comments
14 min read
Next.js job board dedupe with Postgres upsert

Next.js job board dedupe with Postgres upsert

Comments
6 min read
Monitoring TimescaleDB in Production: A Complete Checklist

Monitoring TimescaleDB in Production: A Complete Checklist

1
Comments
4 min read
TimescaleDB Memory Tuning: shared_buffers, work_mem, and Chunk Sizing

TimescaleDB Memory Tuning: shared_buffers, work_mem, and Chunk Sizing

1
Comments
4 min read
How to Build a REST API in Zig (Using Spider Web Framework)
Cover image for How to Build a REST API in Zig (Using Spider Web Framework)

How to Build a REST API in Zig (Using Spider Web Framework)

Comments
6 min read
Building Production-Ready Multi-Tenant SaaS in Rust with Actix-web
Cover image for Building Production-Ready Multi-Tenant SaaS in Rust with Actix-web

Building Production-Ready Multi-Tenant SaaS in Rust with Actix-web

5
Comments
13 min read
Building RAG with pgvector: Why I Stopped Paying for Pinecone

Building RAG with pgvector: Why I Stopped Paying for Pinecone

1
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.