Re: Array indexes, GIN?

Поиск
Список
Период
Сортировка
От Adam L Beberg
Тема Re: Array indexes, GIN?
Дата
Msg-id 45E7D760.3040206@mithral.com
обсуждение исходный текст
Ответ на Re: Array indexes, GIN?  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-performance
Oleg Bartunov wrote on 3/1/2007 10:45 PM:
> On Thu, 1 Mar 2007, Josh Berkus wrote:
>
>> Adam,
>>
>>> On the surface, looks like a job for GIN, but GIN seems undocumented,
>>> specifically mentions it doesn't support the deletes we'll have many of
>>> since it's designed for word searching apparently, the performance
>>> implications are undocumented. I searched, I read, and even IRC'd, and
>>> it seems like GIN is just not used much.
>>
>> It's new (as of 8.2).  And the authors, Oleg and Teodor, are notorious
>> for
>> skimpy documetentation.
>
> We're getting better, we have 72 pages written about new FTS :)

I'm guessing FTS is not quite done since you matched 'FTS' to 'GIN' ;)

> GIN already has support for one dimensional arrays and intarray,
> particularly, too has support of GiN.

Great, so can GIN handle my situation? I'm a little unsure what to make
of "Note: There is no delete operation for ET." in particular since I'm
dealing with large numbers.

--
Adam L. Beberg
http://www.mithral.com/~beberg/

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: Array indexes, GIN?
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1