Re: tsearch2 in PostgreSQL 8.3? - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: tsearch2 in PostgreSQL 8.3?
Date
Msg-id 46C37D43.6060703@cheapcomplexdevices.com
Whole thread Raw
In response to Re: tsearch2 in PostgreSQL 8.3?  (Magnus Hagander <magnus@hagander.net>)
List 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.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: XID wraparound and busy databases
Next
From: "Kevin Grittner"
Date:
Subject: Re: XID wraparound and busy databases