Re: Search for fixed set of keywords

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: Search for fixed set of keywords
Дата
Msg-id Pine.LNX.4.64.0801101503290.26876@sn.sai.msu.ru
обсуждение исходный текст
Ответ на Re: Search for fixed set of keywords  (Jörg Kiegeland <kiegeland@ikv.de>)
Список pgsql-performance
On Thu, 10 Jan 2008, J?rg Kiegeland wrote:

>> Did you try integer arrays with GIN (inverted index) ?
> I now tried this, and GIN turned out to be linear time, compared with GIST
> which was acceptable time. However I tested this only for Z=infinity, for
> Z=1000, GIST/GIN are both not acceptable.

Sorry, I didn't follow your problem, but GIN should be certainly
logarithmic on the number of unique words. Also, it'd be much clear
if you show us your queries and explain analyze.


     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

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

Предыдущее
От: Stephane Bailliez
Дата:
Сообщение: Re: big database performance
Следующее
От: Jared Mauch
Дата:
Сообщение: Re: big database performance