---
title: "Discussion on \"Read this Before Creating Your Next Index in PSQL\" | Hashnode"
description: "Discussion on \"Read this Before Creating Your Next Index in PSQL\". If you are a beginner in your developer journey tasked with optimizing a database query, you must have read about applying indexes. But not all indexes bring performance gains. Some can even degrade it. Read this blog before your create your next ind..."
url: "https://hashnode.com/posts/read-this-before-creating-your-next-index-in-psql/6954732586c4c7189f491aca"
---

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

Discussion

# [Read this Before Creating Your Next Index in PSQL](https://blog.lakshyabuilds.com/read-this-before-creating-your-next-index-in-psql?utm_source=hashnode&utm_medium=feed)

If you are a beginner in your developer journey tasked with optimizing a database query, you must have read about applying indexes. But not all indexes bring performance gains. Some can even degrade it. Read this blog before your create your next ind...

Dec 31, 2025 · 8 min read · blog.lakshyabuilds.com  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#indexing](https://hashnode.com/tag/indexing)
-   [#database-optimization](https://hashnode.com/tag/database-optimization)
-   [#composite-index](https://hashnode.com/tag/composite-index)
-   [#indexing-strategy](https://hashnode.com/tag/indexing-strategy)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#psql](https://hashnode.com/tag/psql)
-   [#postgres](https://hashnode.com/tag/postgres)

## Written by

[Lakshay Gupta](https://hashnode.com/@voidness)

@voidness · India

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

Software Engineering pays my bills, writing blogs over here help me sleep.

My friends used to poke me for writing long messages while texting. I thought why not benefit from it? I have led communities, ran startups, built viral apps, and made youtube vlogs.. Yes, I am an engineer.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
