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.
PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

Comments 1
9 min read
Your Company Does Not Need Another AI Chatbot. It Needs a Knowledge Layer.

Your Company Does Not Need Another AI Chatbot. It Needs a Knowledge Layer.

Comments
12 min read
PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

Comments
9 min read
MongoDB vs Postgres JSONB in 2026: Inserts, Lookups, Updates and Storage, Benchmarked

MongoDB vs Postgres JSONB in 2026: Inserts, Lookups, Updates and Storage, Benchmarked

1
Comments 5
13 min read
Your Test Suite Is Slow Because It Tests Postgres

Your Test Suite Is Slow Because It Tests Postgres

Comments
3 min read
PostgreSQL index bloat: why VACUUM never shrinks an index, and how to measure it with avg_leaf_density

PostgreSQL index bloat: why VACUUM never shrinks an index, and how to measure it with avg_leaf_density

Comments
15 min read
Threads, Pools, Promise.all: Why Your Postgres Falls Over First (Spring Boot vs Node)

Threads, Pools, Promise.all: Why Your Postgres Falls Over First (Spring Boot vs Node)

1
Comments 1
7 min read
How We Handle 10,000+ Product Queries with Django + PostgreSQL Without Breaking a Sweat

How We Handle 10,000+ Product Queries with Django + PostgreSQL Without Breaking a Sweat

1
Comments
1 min read
PostgreSQL Isolation Levels Explained with Python

PostgreSQL Isolation Levels Explained with Python

1
Comments 2
26 min read
pgvector: Embedding Column on the Table or a Separate Embeddings Table?

pgvector: Embedding Column on the Table or a Separate Embeddings Table?

2
Comments 2
9 min read
pgvector Without Embeddings: When a Feature Vector Beats Semantic Search

pgvector Without Embeddings: When a Feature Vector Beats Semantic Search

Comments
6 min read
Supabase Backups and PITR: What Each Plan Covers, Plus a Restore Drill

Supabase Backups and PITR: What Each Plan Covers, Plus a Restore Drill

1
Comments 1
6 min read
Edge Read Slices: Take Read Load Off Your Central Database

Edge Read Slices: Take Read Load Off Your Central Database

Comments
2 min read
We asked an agent to tune 1 slow query on 3 Postgres MCP servers. It had notes.

We asked an agent to tune 1 slow query on 3 Postgres MCP servers. It had notes.

1
Comments
7 min read
Permission Filters and pgvector: Why Your Most Restricted Users Get the Fewest Answers

Permission Filters and pgvector: Why Your Most Restricted Users Get the Fewest Answers

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