---
title: "#postgresql-performance articles | Hashnode"
description: "Explore 33 articles tagged #postgresql-performance on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/postgresql-performance"
---

Tag

# #postgresql-performance

33 posts · 16 followers

[kiran sabne](https://hashnode.com/@kiransabne) · [Sep 18](https://hashnode.com/posts/postgresql-nested-loop-when-is-it-actually-a-problem/6aad16149e5b1cc05dd4d181)

### [PostgreSQL Nested Loop: When Is It Actually a Problem?](https://kiransabne.dev/postgresql-nested-loop-when-is-it-actually-a-problem?utm_source=hashnode&utm_medium=feed)

When a Postgres Nested Loop join is fine vs. when outer rows × inner loops actually costs you — real EXPLAIN ANALYZE examples.

3 min read · [kiransabne.dev](https://kiransabne.dev/postgresql-nested-loop-when-is-it-actually-a-problem?utm_source=hashnode&utm_medium=feed)

[kiran sabne](https://hashnode.com/@kiransabne) · [Sep 18](https://hashnode.com/posts/postgresql-index-bloat-why-it-happens-and-how-to-fix-it/6aacdb14c88db9c85cde799f)

### [PostgreSQL Index Bloat: Why It Happens and How to Fix It](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed)

Why PostgreSQL indexes bloat even after VACUUM, how to measure it with pgstatindex, and when to use REINDEX CONCURRENTLY or pg\_repack to fix it.

6 min read · [kiransabne.dev](https://kiransabne.dev/postgresql-index-bloat-why-it-happens-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed)

[kiran sabne](https://hashnode.com/@kiransabne) · [Aug 22](https://hashnode.com/posts/how-to-read-a-postgresql-execution-plan-the-complete-guide-with-real-examples/6a895774efd93b0140a7add6)

### [How to Read a PostgreSQL Execution Plan: The Complete Guide (With Real Examples)](https://kiransabne.dev/how-to-read-a-postgresql-execution-plan-the-complete-guide-with-real-examples?utm_source=hashnode&utm_medium=feed)

Learn to read PostgreSQL execution plans step by step. EXPLAIN ANALYZE, node types, buffers, and real production examples

17 min read · [kiransabne.dev](https://kiransabne.dev/how-to-read-a-postgresql-execution-plan-the-complete-guide-with-real-examples?utm_source=hashnode&utm_medium=feed)

[Merouan Ballout](https://hashnode.com/@merouanballout) · [Mar 29](https://hashnode.com/posts/postgresql-autovacuum-global-settings-vs-per-table-tuning-complete-guide/69c9234e7816e434a048c8ea)

### [PostgreSQL Autovacuum: Global Settings vs Per-Table Tuning (Complete Guide)](https://merouanballout.hashnode.dev/postgresql-autovacuum-global-settings-vs-per-table-tuning-complete-guide?utm_source=hashnode&utm_medium=feed)

Should I rely on global settings, or tune autovacuum per table?

1 min read · [merouanballout.hashnode.dev](https://merouanballout.hashnode.dev/postgresql-autovacuum-global-settings-vs-per-table-tuning-complete-guide?utm_source=hashnode&utm_medium=feed)

[Muhammad Sajid Bashir](https://hashnode.com/@sajidbashir24h) · [Mar 28](https://hashnode.com/posts/data-gravity-in-laravel-scaling-an-lms-with-postgresql-advanced-patterns/69c761a97cf2706510ae0204)

### [Data Gravity in Laravel: Scaling an LMS with PostgreSQL Advanced Patterns](https://adb-sajidbashir24h.hashnode.dev/data-gravity-in-laravel-scaling-an-lms-with-postgresql-advanced-patterns?utm_source=hashnode&utm_medium=feed)

How we eliminated N+1 queries and 4-second dashboard latencies by pushing logic into the database engine.

3 min read · [adb-sajidbashir24h.hashnode.dev](https://adb-sajidbashir24h.hashnode.dev/data-gravity-in-laravel-scaling-an-lms-with-postgresql-advanced-patterns?utm_source=hashnode&utm_medium=feed)

[Merouan Ballout](https://hashnode.com/@merouanballout) · [Mar 25](https://hashnode.com/posts/the-hidden-killer-of-postgresql-performance-understanding-and-eliminating-bloat/69c39df18a263e79cb0cca5d)

### [The Hidden Killer of PostgreSQL Performance: Understanding and Eliminating Bloat](https://merouanballout.hashnode.dev/the-hidden-killer-of-postgresql-performance-understanding-and-eliminating-bloat?utm_source=hashnode&utm_medium=feed)

In PostgreSQL, every UPDATE or DELETE creates dead tuples. These are old row versions that are no longer visible to any active transaction. They remain in the table and indexes until PostgreSQL’s clea

4 min read · [merouanballout.hashnode.dev](https://merouanballout.hashnode.dev/the-hidden-killer-of-postgresql-performance-understanding-and-eliminating-bloat?utm_source=hashnode&utm_medium=feed)

[Deepansh Gangwar](https://hashnode.com/@mr-deepansh) · [Feb 28](https://hashnode.com/posts/postgresql-complete-beginner-developer-cheatsheet-in-depth/69a2d85e0728161017ddad49)

### [PostgreSQL Complete Beginner → Developer Cheatsheet (In-Depth)](https://blog-deepansh.hashnode.dev/postgresql-complete-beginner-developer-cheatsheet-in-depth?utm_source=hashnode&utm_medium=feed)

Learning postgres Beginner to advanced lavel. posgressql Installation on window 11/pro. Relational Databases, structured query language SQL Cammands

3 min read · [blog-deepansh.hashnode.dev](https://blog-deepansh.hashnode.dev/postgresql-complete-beginner-developer-cheatsheet-in-depth?utm_source=hashnode&utm_medium=feed)

[Rohan Tiwari](https://hashnode.com/@tyranny) · [Feb 18](https://hashnode.com/posts/understanding-heap-file-storage/6995aa1bff9340b3ec1a1ae4)

### [Understanding Heap File Storage](https://rabindranath-tiwari.com.np/understanding-heap-file-storage?utm_source=hashnode&utm_medium=feed)

When you execute INSERT INTO users VALUES (1, 'Alice') in PostgreSQL, what actually happens on disk? Where does that data go? How is it organized? Why does a simple SELECTsometimes cause disk writes? These aren't just academic questions—they're the f...

3 min read · [rabindranath-tiwari.com.np](https://rabindranath-tiwari.com.np/understanding-heap-file-storage?utm_source=hashnode&utm_medium=feed)

[Amrit Poudel](https://hashnode.com/@ambroligence) · [Feb 16](https://hashnode.com/posts/postgresql-production-incident-understanding-a-disk-io-meltdown-after-a-holiday-backlog/6992cf188a4784bb34f2b15e)

### [🧯 PostgreSQL Production Incident: Understanding a Disk I/O Meltdown After a Holiday Backlog](https://systemtroubleshoot.hashnode.dev/postgresql-production-incident-understanding-a-disk-io-meltdown-after-a-holiday-backlog?utm_source=hashnode&utm_medium=feed)

This article documents a real-world PostgreSQL production incident.All business names, schemas, queries, IPs, and identifiers have been anonymized for confidentiality. 📌 System Overview OS: Ubuntu Server 24.04 LTS Database: PostgreSQL 16.x CPU:...

6 min read · [systemtroubleshoot.hashnode.dev](https://systemtroubleshoot.hashnode.dev/postgresql-production-incident-understanding-a-disk-io-meltdown-after-a-holiday-backlog?utm_source=hashnode&utm_medium=feed)

[Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 13](https://hashnode.com/posts/database-indexing-strategy-guide-for-query-performance/698f01c64f9ed3235c98f7fd)

### [Database Indexing Strategy Guide for Query Performance](https://topperblog.hashnode.dev/database-indexing-strategy-guide-for-query-performance?utm_source=hashnode&utm_medium=feed)

B-tree, hash, and composite indexes in PostgreSQL and MySQL

7 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/database-indexing-strategy-guide-for-query-performance?utm_source=hashnode&utm_medium=feed)
