Tag: tag

Oracle AI Database 26ai hybrid search combining VECTOR_DISTANCE semantic similarity with SQL WHERE filters in a single execution plan — no separate round trip required

Hybrid Search in Oracle AI Database 26ai — Combining SQL and Semantic Queries

Posted on by sanjeeva

We had a support tool prototype running vector search against an Oracle error knowledge base. Pure semantic search — query comes in, top five similar errors come back. Worked well in testing. In production, the first complaint arrived within a week: “It keeps returning memory errors when I search for connection problems — they are Read more about Hybrid Search in Oracle AI Database 26ai — Combining SQL and Semantic Queries[…]

Oracle Vector Search: Your First Hands-On Walkthrough

Posted on by sanjeeva

In Post 1 we established the architecture — Oracle 23ai puts vector search inside the database engine, not in a separate system. We titled that post using “23ai” deliberately — because that is the name most production DBAs are still searching for, still referencing in upgrade discussions. Since then, Oracle announced Oracle AI Database 26ai Read more about Oracle Vector Search: Your First Hands-On Walkthrough[…]

Architecture comparison showing complex specialized vector database setup versus simple PostgreSQL pgvector unified solution for AI workloads

Why PostgreSQL Beat Specialized Vector Databases: A DBA’s Perspective

Posted on by sanjeeva

Last Updated: December 2025 | By Sanjeeva Kumar | 20+ Years in Database Systems The Plot Twist Nobody Saw Coming Two weeks ago, PostgreSQL’s pgvector extension released version 0.8.0. Within days, the entire vector database market collectively held its breath. Why? Because that “old guard” relational database just made billion-dollar vector database startups look like Read more about Why PostgreSQL Beat Specialized Vector Databases: A DBA’s Perspective[…]