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

Поиск
Список
Период
Сортировка
От rawi
Тема Re: Index Usage and Running Times by FullTextSearch with prefix matching
Дата
Msg-id 1371559752325-5759645.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: Index Usage and Running Times by FullTextSearch with prefix matching  (rawi <only4com@web.de>)
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: rawi
Дата:
Сообщение: Re: apt.postgresql.org vs. Pitti PPA - install error
Следующее
От: gmb
Дата:
Сообщение: UNNEST result order vs Array data