---
title: "John M Harper (@j79h110) | Hashnode"
description: "Principal Level Database Administrator. Read the latest articles by John M Harper on Hashnode."
url: "https://hashnode.com/@j79h110"
---

@j79h110

# John M Harper

@j79h110 · Joined March 2025

Principal Level Database Administrator

### [BRIN vs B-tree Indexes in PostgreSQL: A Definitive Guide](https://sqljournal.hashnode.dev/brin-vs-b-tree-indexes-in-postgresql-a-definitive-guide?utm_source=hashnode&utm_medium=feed)

In PostgreSQL indexing, B-tree indexes have long been the default choice for most use cases. However, BRIN indexes are often considered a more space-efficient alternative when dealing with multi-billion-row tables. But do they live up to the hype? Th...

7 min read · [sqljournal.hashnode.dev](https://sqljournal.hashnode.dev/brin-vs-b-tree-indexes-in-postgresql-a-definitive-guide?utm_source=hashnode&utm_medium=feed)

[May 7, 2025](https://hashnode.com/posts/brin-vs-b-tree-indexes-in-postgresql-a-definitive-guide/681af7bba56c5ee9faa10917)

### [Optimizing SQL: Sometimes It’s About the Data, Not Just the Query](https://sqljournal.hashnode.dev/optimizing-sql-sometimes-its-about-the-data-not-just-the-query?utm_source=hashnode&utm_medium=feed)

I recently came across a LinkedIn post where someone used two CTEs to pull DISTINCT merchant\_ids from the same table—split by year—and then joined everything back to the orders table. It worked! But it got me thinking. Sometimes, the real challenge i...

5 min read · [sqljournal.hashnode.dev](https://sqljournal.hashnode.dev/optimizing-sql-sometimes-its-about-the-data-not-just-the-query?utm_source=hashnode&utm_medium=feed)

[Mar 23, 2025](https://hashnode.com/posts/optimizing-sql-sometimes-its-about-the-data-not-just-the-query/67dfa329b7863931acbfeee5)
