Making AI Headlines · Page 3

A New Index Promises to Make Finding Similar Things Less Memory-Hungry

Tiger Data has released pg_vectorsearch, an open-source PostgreSQL extension for vector similarity search. The software is in alpha, an early stage that gives developers a chance to test an approach before treating it as a finished fixture of their systems. Vector search helps applications find items that are similar, a useful capability for AI systems working with documents, images and other data. Tiger Data's PRISM index uses partitioning and compression instead of the graph-based approach used by pgvector's HNSW index. The reported result is lower memory requirements and shorter index build times. That distinction matters to people running databases at scale: the useful answer is not merely whether a search works, but what it costs to build and maintain the index that makes it possible. Different approaches can have different tradeoffs, and an alpha release gives users a reason to test those tradeoffs on their own workloads. Open source adds another feature to the package: developers can inspect the code and argue over the results in public. In a field that often announces the future with a trumpet, a database extension has chosen the quieter boast that it may need less memory. Administrators will recognize the genre immediately. The most thrilling sentence in the room is sometimes 'the index fits,' followed closely by 'we measured it ourselves.'

Read this story in the full newspaper →

Satire. Not factual reporting. Read the original reporting from the linked publishers.