---
title: "Discussion on \"PostgreSQL Index Bloat: Why It Happens and How to Fix It\" | Hashnode"
description: "Discussion on \"PostgreSQL Index Bloat: Why It Happens and How to Fix It\". 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."
url: "https://hashnode.com/posts/postgresql-index-bloat-why-it-happens-and-how-to-fix-it/6aacdb14c88db9c85cde799f"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [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.

Sep 18 · 6 min read · kiransabne.dev  
Read the article

-   [#postgres](https://hashnode.com/tag/postgres)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#postgresql-performance](https://hashnode.com/tag/postgresql-performance)
-   [#databases](https://hashnode.com/tag/databases)
-   [#database-optimization](https://hashnode.com/tag/database-optimization)
-   [#databaseinternals](https://hashnode.com/tag/databaseinternals)
-   [#performance-optimization](https://hashnode.com/tag/performance-optimization)
-   [#performance-tuning](https://hashnode.com/tag/performance-tuning)
-   [#backend](https://hashnode.com/tag/backend)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[kiran sabne](https://hashnode.com/@kiransabne)

@kiransabne

  
[View profile](https://hashnode.com/@kiransabne)

SQL Developer and Backend Developer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
