---
title: "Discussion on \"Indexing JSON in PostgreSQL\" | Hashnode"
description: "Discussion on \"Indexing JSON in PostgreSQL\". Indexing JSON documents in PostgreSQL is similar to indexing relational table columns. Although the structure is not enforced at write time like normalized tables, we can still add indexes for our access patterns. In SQL, we index the values we selec..."
url: "https://hashnode.com/posts/indexing-json-in-postgresql/649d9489db80d96029f0ff77"
---

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

Discussion

# [Indexing JSON in PostgreSQL](https://pachot.net/indexing-json-in-postgresql?utm_source=hashnode&utm_medium=feed)

Indexing JSON documents in PostgreSQL is similar to indexing relational table columns. Although the structure is not enforced at write time like normalized tables, we can still add indexes for our access patterns. In SQL, we index the values we selec...

Jun 29, 2023 · 10 min read · pachot.net  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#yugabytedb](https://hashnode.com/tag/yugabytedb)
-   [#distributed-database](https://hashnode.com/tag/distributed-database)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[Franck Pachot](https://hashnode.com/@FranckPachot)

@FranckPachot

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

Dev. advocate on YugabyteDB

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
