Re: tsearch2 in PostgreSQL 8.3?
Ron Mayer <rm_pg@cheapcomplexdevices.com>
From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Magnus Hagander <magnus@hagander.net>
Date: 2007-08-15T22:25:07Z
Lists: pgsql-hackers
Magnus Hagander wrote: > I don't use the functional index part, but for new users I can see how > that's certainly a *lot* easier. Can someone with modern hardware test to see if it's still quite a bit slower than the extra column. I had tried it too years ago; and found the functional index to be quite a bit slower: http://archives.postgresql.org/pgsql-general/2005-10/msg00475.php but it'd be interesting to see if faster CPUs changed this.