From: Joshua D. Drake <jd@commandprompt.com>
To: Gregory Williamson <Gregory.Williamson@digitalglobe.com>
Cc: Dan Kaplan <dkaplan@citizenhawk.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: t1.col like '%t2.col%'
Date: Fri, 29 Feb 2008 17:39:10 -0800
Message-ID: <20080229173910.5645c6e2@commandprompt.com> (raw)
In-Reply-To: <8B319E5A30FF4A48BE7EEAAF609DB233015E341B@COMAIL01.digitalglobe.com>
References: <00c001c87975$a907e2e0$1d00a8c0@dan>
<Pine.LNX.4.64.0802280833040.31180@sn.sai.msu.ru>
<001401c87b2e$26386000$1d00a8c0@dan>
<20080229155642.20ac07be@commandprompt.com>
<8B319E5A30FF4A48BE7EEAAF609DB233015E341B@COMAIL01.digitalglobe.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, 29 Feb 2008 17:30:08 -0700
"Gregory Williamson" <Gregory.Williamson@digitalglobe.com> wrote:
> Joshua Drake spake thusly:
> We used the now deprecated Full Text Indexing (FTI) with some
> handwaving. But that was in PostgreSQL 7.4 and FTI is not in the
> contrib package for some time now. See
> <http://pgfoundry.org/projects/simplefti/; ... I looked at using it
> in 8.1 but my "C" chops weren't up to it, and it depended heavily on
> OIDs which we didn't want to use. Anyway, our business requirement
> evaporated so it doesn't matter to us now.
>
Right but wouldn't this be solved with tsearch2 and pg_tgrm?
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHyLO+ATb/zqfZUUQRAnRlAJ0S0jrc4pSmnBcobEtZvuDkpkWzIACcDP1t
Cwk/j1C2pEXWdANsyZV5f8E=
=9GYn
-----END PGP SIGNATURE-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, Gregory.Williamson@digitalglobe.com, dkaplan@citizenhawk.com
Subject: Re: t1.col like '%t2.col%'
In-Reply-To: <20080229173910.5645c6e2@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox