--- title: PostgreSQL Index Types | daily.dev description: This post explores PostgreSQL index types, including B+Tree, Hash, and GIN indexes. It discusses the benefits of using B+Tree indexes for filtering, range... canonical: https://daily.dev/posts/postgresql-index-types-stm8fztch twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PostgreSQL Index Types | daily.dev og:description: This post explores PostgreSQL index types, including B+Tree, Hash, and GIN indexes. It discusses the benefits of using B+Tree indexes for filtering, range... og:url: https://daily.dev/posts/postgresql-index-types-stm8fztch og:image: https://api.daily.dev/og/posts/STm8fztch.png og:image:alt: PostgreSQL Index Types og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # PostgreSQL Index Types **[Vlad Mihalcea](https://daily.dev/sources/vladmihalcea)** · 15 min read · 30 upvotes · 0 comments ## Summary This post explores PostgreSQL index types, including B+Tree, Hash, and GIN indexes. It discusses the benefits of using B+Tree indexes for filtering, range scans, and sorting. It explains how Hash indexes are useful for equality checks and saving space. It also explains how GIN indexes can speed up JSON-specific operations. The post concludes by mentioning other index types available in PostgreSQL. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#database](https://daily.dev/tags/database), [#golang](https://daily.dev/tags/golang), [#postgresql](https://daily.dev/tags/postgresql), [#sql](https://daily.dev/tags/sql) [View this post on daily.dev](https://daily.dev/posts/postgresql-index-types-stm8fztch) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"PostgreSQL Index Types","url":"https://daily.dev/posts/postgresql-index-types-stm8fztch","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/postgresql-index-types-stm8fztch"},"datePublished":"2024-03-11T13:20:09.799Z","dateModified":"2024-11-16T02:18:52.324Z","description":"This post explores PostgreSQL index types, including B+Tree, Hash, and GIN indexes. It discusses the benefits of using B+Tree indexes for filtering, range...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/23a50ee7aa97aa3f14c8b2236fa16215?_a=AQAEufR","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/23a50ee7aa97aa3f14c8b2236fa16215?_a=AQAEufR","isAccessibleForFree":true,"articleSection":"Vlad Mihalcea","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Vlad Mihalcea","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/5dd0066095304e2ea086956d3ed96c1b","url":"https://daily.dev/sources/vladmihalcea"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/postgresql-index-types-stm8fztch","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":30},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,golang,postgresql,sql","timeRequired":"PT15M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Vlad Mihalcea","item":"https://daily.dev/sources/vladmihalcea"},{"@type":"ListItem","position":3,"name":"PostgreSQL Index Types"}]} ```