Re: Index for similarity search

From: tomas(at)tuxteam(dot)de
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Enrico <scotty(at)linuxtime(dot)it>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index for similarity search
Date: 2007-01-17 08:03:31
Message-ID: 20070117080331.GA24042@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, Jan 16, 2007 at 07:15:58PM +0100, Martijn van Oosterhout wrote:
> On Tue, Jan 16, 2007 at 06:04:07PM +0100, Enrico wrote:
> > Hi,
> > I written an index to improve similarity search like images search, string search etc...
> > My index code is written in C and it is not linked with any dmbs, and I would to connect it to postgresql.
>
> You probably want to build a GiST index, check the docs.

Especially, have a look at hstore and pg_trgrm. They provide good
examples of how to marry similarity hashes with GiST.

Regards

- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFrdhTBcgs9XrR2kYRAl01AJ9OLPIu/3QDxlM28FqEl0cqBUiMoACfShX/
wXv4q4D3HNpOmAnF4WAkJmg=
=/rAE
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-01-17 08:09:48 Re: Idea for fixing the Windows fsync problem
Previous Message Magnus Hagander 2007-01-17 07:56:28 Re: O_DIRECT support for Windows