News for hackers. Stuff that matters.
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.
Re:Hypothetical Indexes in PostgreSQL by fake-name on Tuesday July 02, 2019 @06:49PM (#20340093)
> 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.