Search code examples
How to improve or speed up Postgres query with pg_trgm?...


postgresqlpostgresql-performancepg-trgm

Read More
PostgreSQL GIN index size stuck at 0 bytes...


postgresqlazurepg-trgm

Read More
Strange sorting behavior with bigint column via GiST index in PostgreSQL...


postgresqlpg-trgmbtree-gist

Read More
operator class "gin_trgm_ops" does not exist for access method "gin"...


pythondjangoindexingpytest-djangopg-trgm

Read More
Postgres: How to optimize similarity queries searching columns on multiple tables? (pg_trgm)...


postgresqlperformanceindexingquery-optimizationpg-trgm

Read More
Jooq and postgres: pg_trgm operators in plain sql produce error "operator does not exist"...


javapostgresqljooqpg-trgm

Read More
Is there a way to use pg_trgm like operator with btree indexes on PostgreSQL?...


postgresqlindexingpg-trgm

Read More
How to achieve sub 1s Trigram/Vector search in Postgres when searching long strings...


databasepostgresqlsearchfull-text-searchpg-trgm

Read More
How to group by similar values with pg_trgm...


postgresqlpg-trgm

Read More
How to index a column for leading wildcard search and check progress?...


sqlpostgresqlindexingpattern-matchingpg-trgm

Read More
Real number comparison for trigram similarity...


sqlpostgresqltrigrampg-trgm

Read More
Optimizing a postgres similarity query (pg_trgm + gin index)...


postgresqlpg-trgm

Read More
Implementing K-Gram indexing in postgres...


databasepostgresqlindexingdatabase-indexespg-trgm

Read More
Error while running fuzzy search using pg_trgm extension...


databasepostgresqlfuzzy-searchpg-trgm

Read More
How do I fetch similar posts from database where text length can be more than 2000 characters...


sqlpostgresqlsimilaritypg-trgm

Read More
How to make PostgreSQL use gin_trgm_ops index for equality comparison...


postgresqlpostgresql-performancepg-trgm

Read More
Set GUC parameter or use PGOPTIONS environment variable with PgBouncer...


postgresqlpgbouncerpg-trgm

Read More
Install pg_trgm on postgres 9.4.24...


greenplumpg-trgm

Read More
Index jsonb column keys using GIN and pg_trgm, for ILIKE queries in Rails...


ruby-on-railspostgresqldatabase-indexespg-trgm

Read More
Matching a small table (<1,000 rows) to a large table (>100m rows) using pg_trgm—most efficien...


postgresqlfuzzy-searchpostgresql-12pg-trgm

Read More
Will trigram index on multiple columns make search faster and how to make such search properly?...


postgresqlpg-trgm

Read More
Edge NGram search in PostgreSQL...


postgresqlelasticsearchfull-text-searchpg-trgm

Read More
Postgres `gin_trgm_ops` index not being used...


postgresqlperformancedatabase-performancequery-performancepg-trgm

Read More
How to use pg_trgm operators(e.g. %>) in django framework?...


pythondjangostring-formattingstring-substitutionpg-trgm

Read More
Trigram Index ORDER BY optimization...


postgresqldatabase-indexespostgresql-10pg-trgm

Read More
postgresql pg_trgm.word_similarity_threshold decreasing...


postgresqlpg-trgm

Read More
Change GUC parameter before subquery PostgreSQL...


sqlpostgresqlpg-trgm

Read More
How to speed up pg_trgm?...


sqlpostgresqlpg-trgm

Read More
How is the similarity calculated in Postgres pg_trgm module...


postgresqlpg-trgm

Read More
How to use pg_trgm functions in JOOQ...


postgresqljooqpg-trgm

Read More
BackNext