Philip McClarence

Mar 17

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

#ai #database #performance #postgres

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

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

1

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

2

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

1

4 min read

Philip McClarence

Mar 8

TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

#database #performance #postgres #sql

1

4 min read

Cover image for PostgreSQL Query Optimization: 10 Techniques That Actually Work

Philip McClarence

Mar 8

PostgreSQL Query Optimization: 10 Techniques That Actually Work

#database #performance #postgres #sql

1

12 min read

Cover image for Running PostgreSQL on Kubernetes: Operators, Storage and Production Guide

Philip McClarence

Mar 7

Running PostgreSQL on Kubernetes: Operators, Storage and Production Guide

#database #devops #kubernetes #postgres

11 min read

Cover image for Scaling pgvector: Memory, Quantization, and Index Build Strategies

Philip McClarence

Mar 7

Scaling pgvector: Memory, Quantization, and Index Build Strategies

#ai #database #performance #postgres

1

4 min read

Cover image for PostgreSQL High Availability: Patroni, Replication and Failover Patterns

Philip McClarence

Mar 6

PostgreSQL High Availability: Patroni, Replication and Failover Patterns

#architecture #database #postgres #sre

1

12 min read

Philip McClarence

Mar 6

TimescaleDB Compression: A Complete Guide to 95%+ Storage Reduction

#database #performance #postgres #tutorial

1

4 min read

Cover image for Neon Postgres Review: Is Serverless PostgreSQL Ready for Production?

Philip McClarence

Mar 5

Neon Postgres Review: Is Serverless PostgreSQL Ready for Production?

#architecture #database #postgres #serverless

1

13 min read

Philip McClarence

Mar 5

How TimescaleDB Chunks Actually Work (And Why Size Matters)

#architecture #database #performance #postgres

2

4 min read

Cover image for Your pgvector Queries Are Doing Sequential Scans — Here's Why

Philip McClarence

Mar 5

Your pgvector Queries Are Doing Sequential Scans — Here's Why

#database #machinelearning #performance #postgres

1

4 min read

Cover image for IVFFlat vs HNSW in pgvector: Which Index Should You Use?

Philip McClarence

Mar 4

IVFFlat vs HNSW in pgvector: Which Index Should You Use?

#ai #database #performance #postgres

1

4 min read

Philip McClarence

Mar 4

Choosing the Right chunk_time_interval for Your Workload

#architecture #database #performance #postgres

1

4 min read

Cover image for Supabase vs Firebase in 2026: Which Backend Should You Choose?

Philip McClarence

Mar 3

Supabase vs Firebase in 2026: Which Backend Should You Choose?

#backend #database #firebase #postgres

2

12 min read

Philip McClarence

Mar 3

Optimizing Continuous Aggregate Performance for Large Datasets

#database #dataengineering #performance #postgres

4 min read

Cover image for PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

Philip McClarence

Mar 2

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

#database #mongodb #postgres #sql

1

12 min read

Philip McClarence

Mar 2

Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

#database #performance #postgres #tutorial

4 min read

Cover image for PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

Philip McClarence

Mar 1

PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

#database #performance #postgres #sql

1

10 min read

Philip McClarence

Mar 1

Understanding TimescaleDB Background Workers and Jobs

#architecture #automation #database #postgres

1

4 min read

Philip McClarence

Mar 1

pgvector Distance Functions: Cosine vs L2 vs Inner Product

#database #machinelearning #postgres #sql

1

3 min read

Philip McClarence

Feb 28

PostgreSQL XID Wraparound: What It Is and How to Prevent It

#database #devops #postgres #tutorial

1

4 min read

Philip McClarence

Feb 27

How to Find and Fix Missing Indexes in PostgreSQL

#database #performance #postgres #tutorial

1

4 min read

Philip McClarence

Feb 26

Diagnosing and Resolving Lock Contention in PostgreSQL

3 min read

Philip McClarence

Feb 26

Diagnosing and Resolving Lock Contention in PostgreSQL

#database #performance #postgres #tutorial

1

3 min read

Philip McClarence

Feb 26

Understanding and Fixing Table Bloat in PostgreSQL

5 min read

Philip McClarence

Feb 25

PostgreSQL Autovacuum Tuning: A Practical Guide

#database #performance #postgres #tutorial

5 min read

Philip McClarence

Feb 23

Best PostgreSQL Monitoring Tools for Startups and Growing Teams in 2026

#database #monitoring #performance #postgres

16 min read

Writing Debut

One Year Club