filmov
tv
5mins of Postgres E23: Fuzzy text search & case-insensitive ICU collations in Postgres
Показать описание
Today, we're going to talk about fuzzy text search in Postgres with LIKE/ILIKE, trigrams, levenshtein distances, as well as case-insensitive pattern matching.
*Learn more about pganalyze:*
📑 What we have discussed in this episode of 5mins of Postgres:
*Learn more about pganalyze:*
📑 What we have discussed in this episode of 5mins of Postgres:
0:05:58
5mins of Postgres E23: Fuzzy text search & case-insensitive ICU collations in Postgres
0:01:17
SQL : How to create simple fuzzy search with PostgreSQL only?
0:05:23
5mins of Postgres E22: Reduce Aurora I/O costs with table partitioning, understand partition pruning
0:05:32
5mins of Postgres E61: Collations in Postgres
0:05:22
5mins of Postgres E3: Postgres performance cliffs with large JSONB values and TOAST
0:02:44
Databases: Fuzzy Matching with Postgresql 9.3 (2 Solutions!!)
0:01:57
Fuzzystrmatch Postgresql similarity func with array (2 Solutions!!)
0:06:13
Handling case insensitive strings - EXPLAINING POSTGRESQL
0:00:40
Case insensitive queries in Postgres with the ILIKE operator
0:05:22
5mins of Postgres E6: Optimizing Postgres Text Search with Trigrams and GiST indexes
0:04:02
Create your database with character set encoding!
0:17:36
Scaling Postgres Episode 221 psql Shortcuts, Debugging Deadlocks, Find & Stop Queries, Using SCR...
0:01:10
PostgreSQL: Accent/diacritic insensitive search
0:14:12
PostgreSQL Full Text Search Tutorial
0:01:23
SQL : In PostgreSQL, weird issue about citext performance?
0:07:47
Lightweight text search in Postgres
0:39:20
BZAN 6356 Lecture 2.3: Fuzzy Search and Comparisons in PostgreSQL
0:14:05
Creating a search catalog in PostgreSQL using full text indexing
0:04:59
Databases: Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
0:01:51
Databases: Postgres: Disable 'similarity' column output on 'SELECT SIMILARITY'?
0:01:14
SQL : Similarity function in Postgres with pg_trgm
0:01:10
PostgreSQL performance citext
0:01:49
How to set weights on a Postgres TSVECTOR column?
0:01:36
Columns names are case sensitive on postgres
Комментарии