Microsoft touts scalability of its new PostgreSQL-compatible managed database

Learn extra at:

“In distinction, Azure Database and Cosmos DB for PostgreSQL stays the general-purpose managed Postgres for conventional apps and the distributed, sharded possibility for horizontally scaled multi-tenant workloads respectively,” she mentioned.

“HorizonDB is the AI-era Postgres tier, the place transactional modernization and vector-driven purposes lastly land in the identical engine. It’s meant to be the place the place you each modernize legacy transactional techniques and bolt on RAG, brokers, and embeddings-heavy options with out stitching collectively separate databases and ML endpoints,” mentioned Walter.

One of many issues that has made PostgreSQL so in style with AI builders is its help for vector indexes, mentioned Microsoft, including that in Azure HorizonDB it’s extending that help with superior filtering capabilities within the DiskANN vector index that “allow question predicate pushdowns instantly into the vector similarity search”. This widespread optimization approach filters information as early as attainable within the pipeline to keep away from pointless information processing and transmission.

Leave a reply

Please enter your comment!
Please enter your name here