On Wed, Sep 2, 2015 at 4:29 PM, Jeff Janes <[email protected]> wrote: > On Wed, Sep 2, 2015 at 7:00 AM, Volker Böhm <[email protected]> wrote: >> >> >> >> CREATE INDEX trgm_adresse ON adressen.adresse USING gist >> (normalize_string((btrim((((((((normalize_string((((COALESCE((vorname)::text, >> ''::text) || ' '::text) || (name1)::text))::character varying, >> (-1)))::text || ' '::text) || (normalize_string((COALESCE((strasse)::text, >> ''::text))::character varying, (-2)))::text) || ' '::text) || (plz)::text) >> || ' '::text) || (normalize_string((COALESCE((ort)::text, >> ''::text))::character varying, (-3)))::text)))::character varying) >> gist_trgm_ops); > > > > You might have better luck with gin_trgm_ops than gist_trgm_ops. Have you > tried that?
I just had the exact same problem, and indeed gin fares much better. -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
