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
