Re: Using GIN indexes on 8.2

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Alexander Staubo <alex(at)purefiction(dot)net>, PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using GIN indexes on 8.2
Date: 2006-11-10 19:41:43
Message-ID: 1163187703.12372.12.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

It would also be helpful to update the docs to use GIN where
appropriate.

Regards,
Jeff Davis

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brad Nicholson 2006-11-10 19:51:09 Re: Request for replication advice
Previous Message Andreas Kretschmer 2006-11-10 19:36:50 Re: FK pointing to a VIEW