| 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-----
| 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 |