Re: [PERFORM] query with pg_trgm sometimes very slow

2015-09-08 Thread Merlin Moncure
On Tue, Sep 8, 2015 at 4:21 PM, Tomas Vondra wrote: > On 09/08/2015 09:15 PM, Merlin Moncure wrote: > ... >>> >>> I just had the exact same problem, and indeed gin fares much better. >> >> >> Also, with 9.5 we will see much better worst case performance from gin >> via Jeff's patch: >> >> http://g

Re: [PERFORM] query with pg_trgm sometimes very slow

2015-09-08 Thread Tomas Vondra
On 09/08/2015 09:15 PM, Merlin Moncure wrote: ... I just had the exact same problem, and indeed gin fares much better. Also, with 9.5 we will see much better worst case performance from gin via Jeff's patch: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=97f3014647a5bd57003

Re: [PERFORM] query with pg_trgm sometimes very slow

2015-09-08 Thread Merlin Moncure
On Thu, Sep 3, 2015 at 6:19 PM, Claudio Freire wrote: > On Wed, Sep 2, 2015 at 4:29 PM, Jeff Janes wrote: >> On Wed, Sep 2, 2015 at 7:00 AM, Volker Böhm wrote: >>> >>> >>> >>> CREATE INDEX trgm_adresse ON adressen.adresse USING gist >>> (normalize_string((btrimnormalize_stringCOALESC

Re: [PERFORM] query with pg_trgm sometimes very slow

2015-09-03 Thread Claudio Freire
On Wed, Sep 2, 2015 at 4:29 PM, Jeff Janes wrote: > On Wed, Sep 2, 2015 at 7:00 AM, Volker Böhm wrote: >> >> >> >> CREATE INDEX trgm_adresse ON adressen.adresse USING gist >> (normalize_string((btrimnormalize_stringCOALESCE((vorname)::text, >> ''::text) || ' '::text) || (name1)::tex

Re: [PERFORM] query with pg_trgm sometimes very slow

2015-09-02 Thread Jeff Janes
On Wed, Sep 2, 2015 at 7:00 AM, Volker Böhm wrote: > > > CREATE INDEX trgm_adresse ON adressen.adresse USING gist > (normalize_string((btrimnormalize_stringCOALESCE((vorname)::text, > ''::text) || ' '::text) || (name1)::text))::character varying, > (-1)))::text || ' '::text) || (nor

[PERFORM] query with pg_trgm sometimes very slow

2015-09-02 Thread Volker Böhm
Hi, I have a table for addresses: CREATE TABLE adressen.adresse ( pool_pk integer NOT NULL, adressnr_pk integer NOT NULL, anrede varchar(8), vorname varchar(50) DEFAULT ''::character varying NOT NULL, name1varchar(100)NOT NULL, na