Re: pg_trgm word_similarity query does not use index for input strings longer than 8 characters

2021-12-06 Thread Laurenz Albe
On Tue, 2021-11-30 at 22:38 +0100, pgsql-performa...@jhacker.de wrote: > ## Setup Information > Hardware: Intel i5-8250U, 8GB RAM, encrypted SSD, no RAID > [...] > > Configuration: > The config file was not changed. > [...] > > ## Test Case > [...] > CREATE EXTENSION pg_trgm; > > CREATE TABLE song

pg_trgm word_similarity query does not use index for input strings longer than 8 characters

2021-12-06 Thread pgsql-performance
Hello, recently I wrote a query that provides suggestions from a Postgres table. It should be able to work despite smaller typos and thus I chose to use the pg_trgm extension (https://www.postgresql.org/docs/current/pgtrgm.html). When measuring the performance, I observed great differences in th