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

1

10 min read

Cover image for PostgreSQL Parallel Query: Configuration & Performance Tuning

Philip McClarence

Apr 22

PostgreSQL Parallel Query: Configuration & Performance Tuning

#database #performance #postgres #tutorial

1

3 min read

Cover image for PostgreSQL Point-in-Time Recovery with pgBackRest

Philip McClarence

Apr 21

PostgreSQL Point-in-Time Recovery with pgBackRest

#database #devops #postgres #tutorial

3 min read

Cover image for PostgreSQL BRIN Indexes: When & How to Use Block Range Indexes

Philip McClarence

Apr 20

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

#database #performance #postgres #tutorial

4 min read

Cover image for PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

Philip McClarence

Apr 19

PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

#database #performance #postgres #sql

3 min read

Cover image for PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies

Philip McClarence

Apr 18

PostgreSQL JSONB Indexing: GIN, Expression & Partial Index Strategies

#database #performance #postgres #sql

4 min read

Cover image for PostgreSQL Transaction Isolation Levels Explained

Philip McClarence

Apr 17

PostgreSQL Transaction Isolation Levels Explained

#database #postgres #sql #tutorial

1

4 min read

Cover image for PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

Philip McClarence

Apr 16

PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

#database #monitoring #performance #postgres

4 min read

Cover image for PostgreSQL Monitoring Tools Compared (2026)

Philip McClarence

Apr 15

PostgreSQL Monitoring Tools Compared (2026)

#database #monitoring #postgres #tooling

4 min read

Cover image for PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

Philip McClarence

Apr 14

PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

#database #monitoring #postgres #tutorial

3 min read

Cover image for PostgreSQL Partial Indexes: Targeted Indexing for Faster Queries

Philip McClarence

Apr 13

PostgreSQL Partial Indexes: Targeted Indexing for Faster Queries

#database #performance #postgres #sql

3 min read

Cover image for PostgreSQL Table Partitioning: Range, List & Hash Strategies

Philip McClarence

Apr 12

PostgreSQL Table Partitioning: Range, List & Hash Strategies

#architecture #database #performance #postgres

4 min read

Cover image for PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In

Philip McClarence

Apr 11

PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In

#architecture #database #performance #postgres

4 min read

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

Philip McClarence

Apr 10

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

#database #performance #postgres #sql

4 min read

Cover image for PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

Philip McClarence

Apr 9

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

#database #dataengineering #postgres #sql

4 min read

Cover image for PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

Philip McClarence

Apr 8

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

#database #monitoring #postgres #tutorial

4 min read

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

Philip McClarence

Apr 7

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

#database #monitoring #postgres #tooling

4 min read

Cover image for MyDBA.dev vs pgwatch: Metrics Collection vs Actionable Intelligence

Philip McClarence

Apr 6

MyDBA.dev vs pgwatch: Metrics Collection vs Actionable Intelligence

#database #monitoring #opensource #postgres

4 min read

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

Philip McClarence

Apr 5

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

#database #monitoring #performance #postgres

4 min read

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

Philip McClarence

Apr 4

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

#database #monitoring #performance #postgres

4 min read

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

Philip McClarence

Apr 3

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

#database #devops #monitoring #postgres

4 min read

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

Philip McClarence

Apr 2

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

4 min read

Cover image for Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

Philip McClarence

Apr 1

Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

#database #monitoring #performance #postgres

4 min read

Cover image for Isolating the Query Type That's Killing Your Database

Philip McClarence

Mar 31

Isolating the Query Type That's Killing Your Database

4 min read

Cover image for Schema Diff: Catch Drift Between Staging and Production

Philip McClarence

Mar 30

Schema Diff: Catch Drift Between Staging and Production

#cicd #database #devops #sql

4 min read

Cover image for Interactive Replication Topology: See Your Cluster at a Glance

Philip McClarence

Mar 29

Interactive Replication Topology: See Your Cluster at a Glance

#database #monitoring #performance #postgres

4 min read

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

Philip McClarence

Mar 28

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

#database #monitoring #performance #postgres

4 min read

Cover image for Catching Query Plan Regressions Before They Become Incidents

Philip McClarence

Mar 27

Catching Query Plan Regressions Before They Become Incidents

4 min read

Cover image for Finding the Missing Indexes Your Queries Are Begging For

Philip McClarence

Mar 26

Finding the Missing Indexes Your Queries Are Begging For

#backend #database #performance #sql

3 min read

Cover image for Visualizing Lock Chains: Find the Root Blocker in Seconds

Philip McClarence

Mar 25

Visualizing Lock Chains: Find the Root Blocker in Seconds

#database #performance #postgres #sql

1

4 min read

Cover image for The Index Advisor That Checks Your Replicas Before Recommending a DROP

Philip McClarence

Mar 24

The Index Advisor That Checks Your Replicas Before Recommending a DROP

3 min read

Cover image for Tracking Your Database Health Score Over Time

Philip McClarence

Mar 23

Tracking Your Database Health Score Over Time

#database #monitoring #performance #postgres

3 min read

Cover image for 75 Automated Health Checks That Tell You Exactly What to Fix

Philip McClarence

Mar 22

75 Automated Health Checks That Tell You Exactly What to Fix

3 min read

Cover image for The Slow Query Hidden Inside Your PL/pgSQL Function

Philip McClarence

Mar 21

The Slow Query Hidden Inside Your PL/pgSQL Function

#database #performance #postgres #sql

5 min read

Cover image for 12 Free PostgreSQL Tools That Run Entirely in Your Browser

Philip McClarence

Mar 20

12 Free PostgreSQL Tools That Run Entirely in Your Browser

4 min read

Cover image for One Dashboard for Your Entire PostgreSQL Fleet

Philip McClarence

Mar 19

One Dashboard for Your Entire PostgreSQL Fleet

#database #monitoring #postgres #tooling

2

4 min read

Cover image for Automatic EXPLAIN Plan Collection: Stop Guessing Why Queries Are Slow

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

Cover image for PostgreSQL Alerting That Tells You Why, Not Just What

Philip McClarence

Mar 17

PostgreSQL Alerting That Tells You Why, Not Just What

#database #monitoring #postgres #sre

1

4 min read

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

Philip McClarence

Mar 17

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

#database #monitoring #postgres #tooling

1

11 min read

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

Philip McClarence

Mar 16

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

3 min read

Cover image for Best PostgreSQL Migration Tools: Schema Changes Without Downtime

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

Cover image for Best PostgreSQL IDE and GUI Tools in 2026

Philip McClarence

Mar 15

Best PostgreSQL IDE and GUI Tools in 2026

#database #postgres #productivity #tooling

2

14 min read

Cover image for PostGIS After pg_upgrade: Fixing Version Mismatches and Broken Functions

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

Cover image for PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

Philip McClarence

Mar 13

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

#database #postgres #sql #tutorial

3 min read

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

Philip McClarence

Mar 13

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

#architecture #database #postgres #sql

11 min read

Cover image for PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

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

Cover image for PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

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

Cover image for PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

Philip McClarence

Mar 11

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

#database #mongodb #postgres #sql

3

15 min read

Philip McClarence

Mar 10

TimescaleDB Memory Tuning: shared_buffers, work_mem, and Chunk Sizing

#architecture #database #performance #postgres

1

4 min read

Cover image for Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted

Philip McClarence

Mar 10

Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted

#backend #cloud #database #postgres

1

14 min read

Cover image for PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

Philip McClarence

Mar 9

PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

#database #postgres #sql #tutorial

1

3 min read

Philip McClarence

Mar 9

INSERT Performance Tuning for TimescaleDB

#database #performance #postgres #sql

2

4 min read

Philip McClarence

Mar 8

TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

#database #performance #postgres #sql

1

4 min read

Writing Debut

One Year Club