Re: tsearch2 in PostgreSQL 8.3?

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Subject: Re: tsearch2 in PostgreSQL 8.3?
Date: 2007-08-15 22:25:07
Message-ID: 46C37D43.6060703@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2007-08-15 22:58:19 Re: XID wraparound and busy databases
Previous Message Tom Lane 2007-08-15 22:06:10 Re: XID wraparound and busy databases