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
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 |