Philip McClarence - DEV Community

Philip McClarence

May 4

PostgreSQL Query Rewriting Techniques

#database #performance #postgres #sql

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

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

Philip McClarence

Apr 6

MyDBA.dev vs pgwatch: Metrics Collection vs Actionable Intelligence

#database #monitoring #opensource #postgres

4 min read

Philip McClarence

Apr 5

MyDBA.dev vs Datadog Database Monitoring: PostgreSQL-Native vs Full-Stack Observability

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Apr 4

MyDBA.dev vs pganalyze: Which PostgreSQL Monitor Should You Choose?

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Apr 3

XID Wraparound Recovery: The Runbook Your Database Needs Before It's Too Late

#database #devops #monitoring #postgres

4 min read

Philip McClarence

Apr 2

WAL and Vacuum Monitoring: The Two Metrics That Predict Every Outage

4 min read

Philip McClarence

Apr 1

Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Mar 31

Isolating the Query Type That's Killing Your Database

4 min read

Philip McClarence

Mar 30

Schema Diff: Catch Drift Between Staging and Production

#cicd #database #devops #sql

4 min read

Philip McClarence

Mar 29

Interactive Replication Topology: See Your Cluster at a Glance

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Mar 28

From $1 Placeholders to Executable Queries: Debugging the Parameters That Matter

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Mar 27

Catching Query Plan Regressions Before They Become Incidents

4 min read

Philip McClarence

Mar 26

Finding the Missing Indexes Your Queries Are Begging For

#backend #database #performance #sql

3 min read

Philip McClarence

Mar 25

Visualizing Lock Chains: Find the Root Blocker in Seconds

#database #performance #postgres #sql

1

4 min read

Philip McClarence

Mar 24

The Index Advisor That Checks Your Replicas Before Recommending a DROP

3 min read

Philip McClarence

Mar 23

Tracking Your Database Health Score Over Time

#database #monitoring #performance #postgres

3 min read

Philip McClarence

Mar 22

75 Automated Health Checks That Tell You Exactly What to Fix

3 min read

Philip McClarence

Mar 21

The Slow Query Hidden Inside Your PL/pgSQL Function

#database #performance #postgres #sql

5 min read

Philip McClarence

Mar 20

12 Free PostgreSQL Tools That Run Entirely in Your Browser

4 min read

Philip McClarence

Mar 19

One Dashboard for Your Entire PostgreSQL Fleet

#database #monitoring #postgres #tooling

2

4 min read

Philip McClarence

Mar 18

Automatic EXPLAIN Plan Collection: Stop Guessing Why Queries Are Slow

#automation #database #monitoring #performance

1

4 min read

Philip McClarence

Mar 17

How AI Turns a 27-Point EXPLAIN Plan Audit Into One-Click Query Fixes

#ai #database #performance #postgres

1

9 min read

Philip McClarence

Mar 17

PostgreSQL Alerting That Tells You Why, Not Just What

#database #monitoring #postgres #sre

1

4 min read

Philip McClarence

Mar 17

Best Database Monitoring Tools in 2026: A PostgreSQL DBA's Guide

#database #monitoring #postgres #tooling

1

11 min read

Philip McClarence

Mar 16

Real-Time Session Monitoring: See Every Active Query Right Now

3 min read

Philip McClarence

Mar 16

Best PostgreSQL Migration Tools: Schema Changes Without Downtime

13 min read

Philip McClarence

Mar 15

Preventing XID Wraparound on TimescaleDB Hypertables

#architecture #database #performance #postgres

4 min read

Philip McClarence

Mar 15

Best PostgreSQL IDE and GUI Tools in 2026

#database #postgres #productivity #tooling

2

14 min read

Philip McClarence

Mar 14

PostGIS After pg_upgrade: Fixing Version Mismatches and Broken Functions

#database #devops #postgres #tutorial

1

4 min read

Philip McClarence

Mar 14

Debugging Stale Continuous Aggregates in TimescaleDB

#database #monitoring #performance #postgres

1

4 min read

Philip McClarence

Mar 13

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

#database #postgres #sql #tutorial

3 min read

Philip McClarence

Mar 13

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

#architecture #database #postgres #sql

11 min read

Philip McClarence

Mar 12

PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

#database #performance #postgres #sql

2

3 min read

Philip McClarence

Mar 12

Query Planning Overhead with Many Chunks (And How to Fix It)

#database #performance #postgres #sql

4 min read

Philip McClarence

Mar 12

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

#architecture #database #postgres #sql

11 min read

Philip McClarence

Mar 11

Monitoring TimescaleDB in Production: A Complete Checklist

#database #monitoring #postgres #sql

1

4 min read

Philip McClarence

Mar 11

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

#database #mongodb #postgres #sql

3

15 min read

Writing Debut

One Year Club