"Dan Kaplan" <[EMAIL PROTECTED]> writes:
> I learned a little about pg_trgm here:
> http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
There's also real documentation in the 8.3 release:
http://www.postgresql.org/docs/8.3/static/pgtrgm.html
AFAIK pg_trgm hasn't changed much lately,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 29 Feb 2008 17:30:08 -0700
"Gregory Williamson" <[EMAIL PROTECTED]> 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
> contr
Joshua Drake spake thusly:
> On Fri, 29 Feb 2008 15:52:31 -0800
> "Dan Kaplan" <[EMAIL PROTECTED]> wrote:
>
> > I learned a little about pg_trgm here:
> > http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
> >
> > But this seems like it's for finding similarities, not substrings.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 29 Feb 2008 15:52:31 -0800
"Dan Kaplan" <[EMAIL PROTECTED]> wrote:
> I learned a little about pg_trgm here:
> http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
>
> But this seems like it's for finding similarities, not substr
EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Oleg Bartunov
Sent: Wednesday, February 27, 2008 9:47 PM
To: Dan Kaplan
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] t1.col like '%t2.col%'
On Wed, 27 Feb 2008, Dan Kaplan wrote:
> I've got a lot of rows in one t
On Wed, 27 Feb 2008, Dan Kaplan wrote:
I've got a lot of rows in one table and a lot of rows in another table. I
want to do a bunch of queries on their join column. One of these is like
this: t1.col like '%t2.col%'
We have an idea how to speedup wildcard search at the expense of the size -
I've got a lot of rows in one table and a lot of rows in another table. I
want to do a bunch of queries on their join column. One of these is like
this: t1.col like '%t2.col%'
I know that always sucks. I'm wondering how I can make it better. First, I
should let you know that I can likely ho
