Re: Index Usage and Running Times by FullTextSearch with prefix matching

From: rawi <only4com(at)web(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Index Usage and Running Times by FullTextSearch with prefix matching
Date: 2013-06-18 12:49:12
Message-ID: 1371559752325-5759645.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

rawi wrote
>
> Tom Lane-2 wrote
>> FWIW, I get fairly decent performance for cases like this in HEAD
>> (at least with a GIN index; GIST seems much less able to do well with
>> short prefixes). What PG version are you testing?
> Thank you Tom,
>
> I'm testing on PG 9.1 on UbuntuServer 12.10, 64bit
>
> I'll update to 9.2 the next days and try again.
>
> Kind Regards
> Rawi

Just tested with 9.2: pretty much the same

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Index-Usage-and-Running-Times-by-FullTextSearch-with-prefix-matching-tp5759021p5759645.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message gmb 2013-06-20 10:40:57 UNNEST result order vs Array data
Previous Message rawi 2013-06-18 11:31:01 Re: apt.postgresql.org vs. Pitti PPA - install error