News for hackers. Stuff that matters.
Re:Investing in new vector database development vs enhancing... by aforwardslash on Sunday November 26, 2023 @04:19AM (#38420285)
I love Postgres, but you're comparing apples and oranges. You don't have the same level of query sophistication neither the same indexing quality you get from eg. elasticsearch. As a quick example, the other day I got a bug in PostgreSQL because "searching" does not perform diacritics conversion. Also, stuff like stop words, similarity search and whatnot either required dedicated indexes or are downright "round hole square peg" problems.
Re:Investing in new vector database development vs enhancing... by mkarrmann on Sunday November 26, 2023 @10:12AM (#38422162)
I believe they're being rhetorical, and agree that there are good reasons to use elasticsearch over postgres.