All
Articles 130,411Blog Posts 135,035Tech Tutorials 33,729Research Papers 25,422News 18,473
⚡ AI Lessons
Dev.to · Philip McClarence
7h ago
The 'FATAL: no pg_hba.conf entry for host' error is really three different probl
If you’re reading this at 11:00 PM because your deployment logs are screaming no pg_hba.conf entry...
Dev.to · Philip McClarence
2d ago
lib/tasks/force_drop.rake
ERROR: database "mydb" is being accessed by other users DETAIL: There is 1 other session using...
Dev.to · Philip McClarence
3d ago
Postgres vs Redis, Mongo, and RabbitMQ: Do You Really Need All Four?
There is a recurring cycle in database architecture. A team starts with a single relational database...
Dev.to · Philip McClarence
3d ago
Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi
Title: The 5 Postgres Schema Mistakes That Kill Performance at Scale (and How to Fix Them) Target...
Dev.to · Philip McClarence
4d ago
Five schema-design habits that look harmless in a migration file — unbounded VAR
Five schema mistakes I keep finding in migration files. Each one zero alarms, zero errors, and starts...
Dev.to · Philip McClarence
5d ago
FATAL: no pg_hba.conf entry for host: a diagnostic flow for a symptom with sever
I’ve been paged for this error more times than I want to admit, and every time it is a different root...
Dev.to · Philip McClarence
1w ago
Postgres: force drop a database that is being accessed by other users
You are trying to drop an old database and Postgres gives you this: ERROR: database...
Dev.to · Philip McClarence
1w ago
Bitmap Heap Scan in Postgres: When It’s Smart and When It’s a Symptom
I do not panic when I see Bitmap Heap Scan in a Postgres plan anymore. For years I treated it like a...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
PostgreSQL Plan Signatures: Quick Reference
PostgreSQL Plan Signatures: Quick Reference A scannable lookup companion to the Complete...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
PostgreSQL Query Anti-Patterns and Common Mistakes
Most of the articles in this series are about making reasonable queries faster. This one is about...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
PostgreSQL Query Rewriting Techniques
PostgreSQL Query Rewriting Techniques The previous articles in this series covered...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
PostgreSQL Aggregate and Window Function Tuning
GROUP BY and window functions look declarative — the query says what it wants, and PostgreSQL figures...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
PostgreSQL Subquery and CTE Optimization
Every SELECT in PostgreSQL is made of smaller SELECTs, even when it doesn't look that way. WHERE col...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
PostgreSQL Join Optimization: Nested Loop, Hash, and Merge
PostgreSQL has three join algorithms. The planner picks between them for every join in every query,...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
PostgreSQL Index Usage and Optimization
PostgreSQL Index Usage and Optimization Indexing is the single biggest lever in SQL...
Dev.to · Philip McClarence
⚡ AI Lesson
2mo ago
Reading PostgreSQL EXPLAIN and EXPLAIN ANALYZE Output
Every PostgreSQL performance conversation eventually lands on a question that sounds trivial: what...
Dev.to · Philip McClarence
⚡ AI Lesson
3mo ago
The Complete Guide to PostgreSQL SQL Query Analysis & Optimization
Most PostgreSQL performance work is wasted because it starts from the wrong end. Someone notices a...
Dev.to · Philip McClarence
⚡ AI Lesson
3mo ago
PostgreSQL Parallel Query: Configuration & Performance Tuning
PostgreSQL Parallel Query: Configuration & Performance Tuning Your analytical query...
Dev.to · Philip McClarence
⚡ AI Lesson
3mo ago
PostgreSQL Point-in-Time Recovery with pgBackRest
PostgreSQL Point-in-Time Recovery with pgBackRest pg_dump gives you a snapshot at the...
Dev.to · Philip McClarence
3mo ago
PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes
PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes You have a...
Dev.to · Philip McClarence
3mo ago
PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE
PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE You have an index on...
Dev.to · Philip McClarence
3mo ago
PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies
PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies JSONB is one of...
Dev.to · Philip McClarence
3mo ago
PostgreSQL Transaction Isolation Levels Explained
PostgreSQL Transaction Isolation Levels Explained If you've ever had a subtle data...
Dev.to · Philip McClarence
3mo ago
PostgreSQL Replication Slots: Create, Monitor & Troubleshoot
PostgreSQL Replication Slots: Create, Monitor & Troubleshoot A replication slot...
DeepCamp AI