MariaDB innovation: vector index performance
6 days ago
- #Vector Search
- #MariaDB
- #Performance Benchmark
- MariaDB 12.3 shows improved vector search recall vs precision compared to MariaDB 11.8.
- MariaDB 11.8 outperforms Postgres 18.2 with pgvector 0.8.1 in vector search recall vs precision.
- Performance improvements in MariaDB 12.3 are more noticeable with larger datasets.
- MariaDB 12.3 uses less CPU per query, confirmed by vmstat monitoring.
- Benchmarks were conducted using ann-benchmarks on a high-performance server (Hetzner ax162-s).
- Tests included dbpedia-openai datasets of sizes 100k, 500k, and 1000k.
- MariaDB and Postgres configurations were compiled from source for the tests.
- Storage reads were minimized as tables and indexes were cached.
- MariaDB 12.3 consistently delivered the best performance across all tested datasets.