Philip McClarence - DEV Community

Philip McClarence

Aug 11

pg_cron Tutorial: Schedule Postgres Jobs and Monitor Them

9 min read

Philip McClarence

Aug 10

Aurora PostgreSQL Storage Model: What Actually Changed

9 min read

Philip McClarence

Aug 9

Postgres Is Down: A 5-Check Triage Tree for Fast Recovery

10 min read

Philip McClarence

Aug 9

pgvector in Production: HNSW, Filtering, and Tuning

9 min read

Philip McClarence

Aug 8

PostgreSQL Transaction ID Wraparound: The Slow-Motion Outage You Can See Coming

5 min read

Philip McClarence

Aug 8

pg_cancel_backend vs pg_terminate_backend Explained

8 min read

Philip McClarence

Aug 8

Postgres TOAST Storage: Where Your Big JSONB Really Lives

9 min read

Philip McClarence

Aug 7

Postgres Row-Level Security: 5 Policies That Actually Work

10 min read

Philip McClarence

Aug 7

Postgres Full-Text Search: The Setup You Should Ship

10 min read

Philip McClarence

Aug 6

Postgres Wait Events: Stop Guessing, Start Counting

11 min read

Philip McClarence

Aug 6

No pg_hba.conf Entry for Host: 5 Real Causes & Fixes

10 min read

Philip McClarence

Aug 5

Postgres max_connections: The Real Memory Math

8 min read

Philip McClarence

Aug 5

UUID vs BIGINT Primary Keys in Postgres: What Actually Bloats

9 min read

Philip McClarence

Aug 3

Why Postgres DELETE Doesn't Free Disk Space (FSM Explained)

8 min read

Philip McClarence

Aug 3

Postgres Free Space Map: Why DELETE Won't Shrink Tables

9 min read

Philip McClarence

Aug 3

Postgres Transaction ID Wraparound: The Shutdown Is Working As Designed

8 min read

Philip McClarence

Aug 3

Postgres Transaction ID Wraparound: A Practical Guide

5 min read

Philip McClarence

Aug 3

Postgres can explode a JSONB array into queryable rows directly in SQL — jsonb_a

7 min read

Philip McClarence

Aug 2

Postgres Bitmap Heap Scan Explained with Examples

5 min read

Philip McClarence

Aug 1

Postgres Zero-Downtime Major Upgrade with Logical Replication

4 min read

Philip McClarence

Aug 1

That Password Prompt on a Fresh Postgres Install? It’s pg_hba.conf, Not a Bug.

4 min read

Philip McClarence

Aug 1

Five Schema Mistakes That Silently Kill Postgres Performance at Scale

8 min read

Philip McClarence

Aug 1

Postgres Logical vs Physical Replication: When to Use Each

4 min read

Philip McClarence

Jul 23

UUID vs BIGINT Primary Keys: Beyond Index Bloat

4 min read

Philip McClarence

Jul 22

For transactional job queues, just use Postgres

4 min read

Philip McClarence

Jul 22

The 'FATAL: no pg_hba.conf entry for host' error is really three different probl

#database #devops #postgres

2 min read

Philip McClarence

Jul 20

Postgres vs Redis, Mongo, RabbitMQ: Should You Consolidate?

3 min read

Philip McClarence

Jul 20

lib/tasks/force_drop.rake

#database #debugging #postgres #ruby

7 min read

Philip McClarence

Jul 19

Postgres vs Redis, Mongo, and RabbitMQ: Do You Really Need All Four?

#architecture #database #postgres #systemdesign

8 min read

Philip McClarence

Jul 19

Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

#database #performance #postgres #sql

7 min read

Philip McClarence

Jul 17

Five schema-design habits that look harmless in a migration file — unbounded VAR

#architecture #database #performance #sql

2 min read

Philip McClarence

Jul 17

FATAL: no pg_hba.conf entry for host: a diagnostic flow for a symptom with sever

#database #debugging #networking #postgres

1

7 min read

Philip McClarence

Jul 15

Postgres: force drop a database that is being accessed by other users

#database #postgres #sql #tutorial

4 min read

Philip McClarence

Jul 13

Bitmap Heap Scan in Postgres: When It’s Smart and When It’s a Symptom

#database #performance #postgres #sql

1

7 min read

Philip McClarence

May 6

PostgreSQL Plan Signatures: Quick Reference

#database #performance #postgres #sql

7 min read

Philip McClarence

May 5

PostgreSQL Query Anti-Patterns and Common Mistakes

#database #performance #postgres #sql

1

7 min read

Philip McClarence

May 4

PostgreSQL Query Rewriting Techniques

#database #performance #postgres #sql

1

9 min read

Philip McClarence

May 1

PostgreSQL WHERE Clause Optimization

#database #performance #postgres #sql

9 min read

Philip McClarence

Apr 30

PostgreSQL Aggregate and Window Function Tuning

#database #performance #postgres #sql

9 min read

Philip McClarence

Apr 29

PostgreSQL Subquery and CTE Optimization

#database #performance #postgres #sql

1

8 min read

Philip McClarence

Apr 28

PostgreSQL Join Optimization: Nested Loop, Hash, and Merge

#database #performance #postgres #sql

11 min read

Philip McClarence

Apr 27

PostgreSQL Index Usage and Optimization

#database #performance #postgres #sql

7 min read

Philip McClarence

Apr 24

Reading PostgreSQL EXPLAIN and EXPLAIN ANALYZE Output

#database #performance #postgres #tutorial

14 min read

Philip McClarence

Apr 23

The Complete Guide to PostgreSQL SQL Query Analysis & Optimization

#database #performance #postgres #sql

2

10 min read

Philip McClarence

Apr 22

PostgreSQL Parallel Query: Configuration & Performance Tuning

#database #performance #postgres #tutorial

4

1

3 min read

Philip McClarence

Apr 21

PostgreSQL Point-in-Time Recovery with pgBackRest

#database #devops #postgres #tutorial

3 min read

Philip McClarence

Apr 20

PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes

#database #performance #postgres #tutorial

4 min read

Philip McClarence

Apr 19

PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

#database #performance #postgres #sql

3 min read

Philip McClarence

Apr 18

PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies

#database #performance #postgres #sql

4 min read

Philip McClarence

Apr 17

PostgreSQL Transaction Isolation Levels Explained

#database #postgres #sql #tutorial

1

4 min read

Philip McClarence

Apr 16

PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Apr 15

PostgreSQL Monitoring Tools Compared (2026)

#database #monitoring #postgres #tooling

4 min read

Philip McClarence

Apr 14

PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

#database #monitoring #postgres #tutorial

3 min read

Philip McClarence

Apr 13

PostgreSQL Partial Indexes: Targeted Indexing for Faster Queries

#database #performance #postgres #sql

3 min read

Philip McClarence

Apr 12

PostgreSQL Table Partitioning: Range, List & Hash Strategies

#architecture #database #performance #postgres

4 min read

Philip McClarence

Apr 11

PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In

#architecture #database #performance #postgres

4 min read

Philip McClarence

Apr 10

PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search

#database #performance #postgres #sql

4 min read

Philip McClarence

Apr 9

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

#database #dataengineering #postgres #sql

4 min read

Philip McClarence

Apr 8

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

#database #monitoring #postgres #tutorial

4 min read

Philip McClarence

Apr 7

MyDBA.dev vs Percona PMM: Deep PostgreSQL Intelligence vs Multi-Database Monitoring

#database #monitoring #postgres #tooling

4 min read

Writing Debut

One Year Club