DEV Community

# 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.
Read‑your‑writes on replicas: PostgreSQL WAIT FOR LSN and MongoDB Causal Consistency

Read‑your‑writes on replicas: PostgreSQL WAIT FOR LSN and MongoDB Causal Consistency

Comments
4 min read
I indexed 30 million Hacker News posts into a single Postgres database. Here is what I learned about pgvector at scale.

I indexed 30 million Hacker News posts into a single Postgres database. Here is what I learned about pgvector at scale.

Comments
4 min read
How We Added Folders and Tags to Organize Video Libraries

How We Added Folders and Tags to Organize Video Libraries

2
Comments
4 min read
PostgreSQL VACUUM explained — 5 things you must understand about database maintenance

PostgreSQL VACUUM explained — 5 things you must understand about database maintenance

Comments
5 min read
The Likes Table Problem: Why We Went Polymorphic.

The Likes Table Problem: Why We Went Polymorphic.

Comments
3 min read
PostgreSQL vs MySQL: A 2026 Production Decision Framework

PostgreSQL vs MySQL: A 2026 Production Decision Framework

Comments
5 min read
Introducing QueryForge: An Enterprise Database Client

Introducing QueryForge: An Enterprise Database Client

Comments
1 min read
Building a Payment Gateway That Doesn't Lie: How I Solved Distributed State Failures in Go

Building a Payment Gateway That Doesn't Lie: How I Solved Distributed State Failures in Go

Comments
6 min read
Scaling PostgreSQL without Microservices: Lessons from Notion’s 480 Shards

Scaling PostgreSQL without Microservices: Lessons from Notion’s 480 Shards

Comments
3 min read
Zero-Downtime Embedding Migration: Switching from text-embedding-004 to text-embedding-3-large in Production

Zero-Downtime Embedding Migration: Switching from text-embedding-004 to text-embedding-3-large in Production

Comments
3 min read
How We Tracked 10,000,000 Spins Per Day with Go and PostgreSQL Partitioning

How We Tracked 10,000,000 Spins Per Day with Go and PostgreSQL Partitioning

Comments
10 min read
Supabase vs Firebase in 2026: The Honest Comparison After Using Both in Production

Supabase vs Firebase in 2026: The Honest Comparison After Using Both in Production

Comments
17 min read
Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

Comments
8 min read
Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

Comments
8 min read
Racing Against 2 Billion: How We Survived a PostgreSQL Transaction ID Wraparound on a 2TB Production Table

Racing Against 2 Billion: How We Survived a PostgreSQL Transaction ID Wraparound on a 2TB Production Table

Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.