corpus.blog
41,554 blogs · 4,830,141 posts Claim your blog
Record · corpus.blog/posts/01a08724-6f3e-7122-858f-b6ed332eb9d3

Optimizing Postgres Text Search with Trigrams

alexklibisz.com · published 18 February 2022

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 alexklibisz.com Wayback capture
0blogs citing
First cited
—
Most recent
—
Rank this month
not ranked
External links
27
Words captured
11,247

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://www.postgresql.org/docs/14/pgtrgm.html
postgresql.org
https://www.postgresql.org/docs/14/textsearch.html
postgresql.org
https://github.com/alexklibisz/site-projects/tree/main/optimizing-postgres-text-search-with-trigrams
github.com
https://hub.docker.com/r/bitnami/postgresql/tags
hub.docker.com
https://www.postgresql.org/docs/14/runtime-config.html
postgresql.org
https://www.postgresql.org/docs/14/runtime-config-query.html
postgresql.org
http://jmcauley.ucsd.edu/data/amazon/links.html
jmcauley.ucsd.edu
https://www.postgresql.org/docs/14/sql-explain.html
postgresql.org
https://github.com/dalibo/pev2
github.com
https://en.wikipedia.org/wiki/Jaccard_index
en.wikipedia.org
https://www.postgresql.org/docs/14/indexes-expressional.html
postgresql.org
https://news.ycombinator.com/item?id=30433269
news.ycombinator.com
https://www.reddit.com/r/PostgreSQL/comments/swe8v8/optimizing_postgres_text_search_with_trigrams/
reddit.com
https://www.scalingpostgres.com/episodes/204-optimizing-trigram-search-replication-review-logical-improvements-timescale-investment/
scalingpostgres.com
https://pganalyze.com/blog/5mins-postgres-optimizing-postgres-text-search-trigrams-gist-indexes
pganalyze.com
https://youtu.be/yih3qEiIC_U?t=510
youtu.be
https://www.postgresql.org/docs/14/ddl-generated-columns.html
postgresql.org
https://wiki.postgresql.org/wiki/Incremental_View_Maintenance
wiki.postgresql.org
https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/
about.gitlab.com
https://about.gitlab.com/blog/2019/03/20/enabling-global-search-elasticsearch-gitlab-com/
about.gitlab.com
https://about.gitlab.com/blog/2019/07/16/elasticsearch-update/
about.gitlab.com
https://about.gitlab.com/blog/2020/04/28/elasticsearch-update/
about.gitlab.com
https://docs.gitlab.com/ee/administration/troubleshooting/elasticsearch.html
docs.gitlab.com
https://gitlab.com/gitlab-org/gitlab-foss/-/issues/42442
gitlab.com
http://cseweb.ucsd.edu/~jmcauley/pdfs/www16a.pdf
cseweb.ucsd.edu
http://cseweb.ucsd.edu/~jmcauley/pdfs/sigir15.pdf
cseweb.ucsd.edu
https://postgres.ai/blog/20220106-explain-analyze-needs-buffers-to-improve-the-postgres-query-optimization-process
postgres.ai