Last Updated: October 2026 · Tested On: Oracle AI Database 26ai Enterprise Edition Release 23.26.4.1.0 on OCI Base Database Service · Lab: PDB CDBDEV, schema DDVUSR Sound familiar? The application team switched embedding models on Friday evening. The Oracle VECTOR data type column was declared VECTOR(384, FLOAT32) six months ago, the new model emits 768 Read more about Oracle VECTOR Data Type: Storage, Dimensions, Metrics[…]
We have run vector search workloads on both Oracle AI Database 26ai and PostgreSQL with pgvector and we are here to show you the architectural breakdown of Oracle AI Database 26ai vector search vs pgvector. The technical capabilities of both are real — pgvector works, and PostgreSQL shops have built production vector search on it. Read more about Oracle AI Database 26ai Vector Search vs PostgreSQL pgvector — A DBA’s Perspective[…]
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[…]
In Post -2 of this series, We had a vector search query running clean in development — ten milliseconds, HNSW index in the plan, results looking right. The moment the same query hit a table with eight million rows in staging, response time jumped to forty seconds. The execution plan had quietly switched to TABLE Read more about Vector Indexes in Oracle AI Database 26ai — How HNSW and IVF Work Under the Hood[…]
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[…]