News for hackers. Stuff that matters.

A comment on Vector database is not a separate database category. Parent comment

Re:Vector database is not a separate database category by smilliken on Tuesday October 03, 2023 @02:55PM (#37756014)
Btree isn't a very useful index type for a vector, though. GIN, GIST, and the handful of new extensions optimizing for vector search are what you'd want (and don't have this limitation).

Aside, you can increase the size of tuples you can index in a postgresql btree by increasing the postgresql page size (requires a recompile and creating a new database instance).

[ Parent | on HN ]
Re:Vector database is not a separate database category by sgarland on Tuesday October 03, 2023 @05:47PM (#37758029)
Agreed to the first, but you have to first know that those exist (and what they’re good for). This leads into my second point: IME, the Venn diagram for “people making AI stuff” and “people capable of compiling and running their own DB in a reliable manner” has no overlap.
[ Parent | on HN ]