Record · corpus.blog/posts/01a0b68b-2504-7015-bb60-2acfb54dc78a

Understanding Postgres GIN Indexes: The Good and the Bad

pganalyze.com · published 2 December 2021

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at pganalyze.com Wayback capture

2blogs citing

First cited: 10 Jan 2022
Most recent: 13 Jun 2025
Rank this month: not ranked
Links from this post: 22
Words captured: 3,534

Cited by

Blog

In the post

Date

neon.com

Comparing Native Postgres, ElasticSearch, and pg_search for Full-Text Search Read at the source ↗

13 Jun 2025

sachinsu.github.io

PostgreSQL Read at the source ↗

10 Jan 2022

Links from this post

Link

Host

https://www.sai.msu.su/~megera/wiki/Gin

sai.msu.su

https://pganalyze.com/ebooks/efficient-search-in-rails-with-postgres

pganalyze.com

https://www.postgresql.org/message-id/flat/26038.1559516834%40sss.pgh.pa.us

postgresql.org

https://wiki.postgresql.org/images/2/25/Full-text_search_in_PostgreSQL_in_milliseconds-extended-version.pdf

wiki.postgresql.org

Efficient Postgres Full Text Search in Django Read at the source ↗

pganalyze.com

Full Text Search in Milliseconds with Rails and PostgreSQL Read at the source ↗

pganalyze.com

https://www.postgresql.org/docs/current/textsearch-indexes.html

postgresql.org

https://www.postgresql.org/docs/14/textsearch-indexes.html

postgresql.org

https://github.com/postgrespro/rum

github.com

https://pganalyze.com/ebooks/postgres-indexing

pganalyze.com

https://www.postgresql.org/message-id/flat/56B332B6.1040109%40promani.be

postgresql.org

https://gitlab.com/gitlab-org/gitlab/-/issues/336930

gitlab.com

https://gitlab.com/gitlab-com/gl-infra/production/-/issues/4725

gitlab.com

https://pganalyze.com/index-advisor

pganalyze.com

https://wiki.postgresql.org/wiki/Profiling_with_perf

wiki.postgresql.org

https://www.youtube.com/watch?v=Brt41xnMZqo&t=1949s

youtube.com

https://twitter.com/intent/tweet?text=%E2%80%9DUnderstanding%20Postgres%20GIN%20Indexes%3A%20The%20Good%20and%20the%20Bad%22%20-%20In%20this%20article,%20%40pganalyze%20shows%20how%20to%20index%20JSONB,%20text%20search%20and%20more%20with%20GIN,%20and%20why%20index%20updates%20can%20get%20expensive%3A%20https://pganalyze.com/blog/gin-index

twitter.com

Using Postgres CREATE INDEX: Understanding operator classes, index types & more Read at the source ↗

pganalyze.com

How we deconstructed the Postgres planner to find indexing opportunities Read at the source ↗

pganalyze.com

Efficient Pagination: PostgreSQL and Django Read at the source ↗

pganalyze.com

https://pganalyze.com/webinars/how-to-reason-about-indexing-your-postgres-database

pganalyze.com

https://pganalyze.com/blog/5mins-postgres-for-app-developers-tables-indexes

pganalyze.com