5mins Of Postgres E6: Optimizing Postgres Text Search With Trigrams And Gist Indexes

2023 5:22
Synopsis
Today, we're looking at optimizing Postgres text search with trigrams and take a closer look at GiST indexes. Find the article on ...

You Might Also Like

5mins of Postgres E23: Fuzzy text search & case-insensitive ICU collations in Postgres 5:58
5mins Of Postgres E23: Fuzzy Text Search & Case-insensitive ...
2023
PostgreSQL indexes - GiST index. Easy explanation. Full-text search and spatial data. 8:08
Postgresql Indexes - Gist Index. Easy Explanation. Full-text...
2026
5mins of Postgres E48: Benchmarking multi column, covering and hash indexes in Postgres 5:33
5mins Of Postgres E48: Benchmarking Multi Column, Covering A...
2023
PostgreSQL Full Text Search Tutorial 14:12
Postgresql Full Text Search Tutorial
2024
SQL : Why is postgres trigram word_similarity function not using a gin index? 0:57
Sql : Why Is Postgres Trigram Word_similarity Function Not U...
2024
Creating a search catalog in PostgreSQL using full text indexing 14:05
Creating A Search Catalog In Postgresql Using Full Text Inde...
2023
SQL indexing best practices | How to make your database FASTER! 4:08
Sql Indexing Best Practices | How To Make Your Database Fast...
2023
Scaling Postgres Episode 204 Optimizing Trigram Search, Replication Review, Logical Improvement 18:43
Scaling Postgres Episode 204 Optimizing Trigram Search, Repl...
2023
5mins of Postgres E38: BRIN indexes, tuning pages_per_range & determining correlation with pg_stats 5:16
5mins Of Postgres E38: Brin Indexes, Tuning Pages_per_range ...
2023
Mastering PostgreSQL indexing made easy! 0:38
Mastering Postgresql Indexing Made Easy!
2024
Databases: PostgreSQL FTS and Trigram-similarity Query Optimization 3:17
Databases: Postgresql Fts And Trigram-similarity Query Optim...
2022
Download Options
Choose a download method below. All links open in new tabs.
Service Features Action
SaveFrom
MP4 & MP3 • HD Quality • Browser Extension Available
Download
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.