Re:Hypothetical Indexes in PostgreSQL
by tsomctl on Tuesday July 02, 2019 @04:21PM
(#20339069)
Hey, fake-name, I've been following your work. Have you looked into faiss from Facebook or annoy from Spotify? Their biggest drawback is that you can't modify the index, you have to create a new one if you want to add additional entries.
[ Parent
| on HN ]
> Their biggest drawback is that you can't modify the index
I hadn't looked into them, but being read only would make them useless for my use case.
Basically, my application is online zips-of-images set deduplication, with a continuous input stream of files. I have to be able to add new values continuously.