Re: Using GIN indexes on 8.2

On Friday 10 November 2006 14:41, Jeff Davis wrote:
> On Fri, 2006-11-10 at 20:39 +0300, Teodor Sigaev wrote:
> > >> Use @>, <@ operations instead of @ and ~
> > >> Look for discussions in -hackers for reasons of changing names
> > >
> > > Ah, many thanks. How about updating those web pages? :)
> >
> > Now they are in core:
> > http://developer.postgresql.org/pgdocs/postgres/functions-array.html
> >
> > >> Pls, why don't you use tsearch2 with GIN?
> > >
> > > Perhaps -- is there any documentation on this?
> >
> > Nothing special, just use GIN index instead of GiST.
>
> I think a section showing when to use GiST versus GIN would be very
> helpful (assuming there are still good reasons to use GiST). I would
> certainly read it.
>

I was wondering this same thing, but it appears the trade-off is disk
space/update speed (GiST) vs. query times (Gin). Magnus had a couple of nice
posts in his blog you might want to check out:
http://people.planetpostgresql.org/mha/

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL