Re: Array indexes, GIN?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux