Index for similarity search

Started by Enricoalmost 19 years ago4 messages
#1Enrico
scotty@linuxtime.it

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.

Any suggest to begin my work?

Thanks
Enrico

--
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!!
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi

#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Enrico (#1)
Re: Index for similarity search

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.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Show quoted text

From each according to his ability. To each according to his ability to litigate.

#3Noname
tomas@tuxteam.de
In reply to: Martijn van Oosterhout (#2)
Re: Index for similarity search

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

#4Enrico
scotty@linuxtime.it
In reply to: Martijn van Oosterhout (#2)
Re: Index for similarity search

You probably want to build a GiST index, check the docs.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

From each according to his ability. To each according to his ability to litigate.

Many thanks

--
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!!
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi