[Feature]: Support OceanBase/seekdb Index-Merge for Index Efficiency #30
Description
Describe your use case
Currently, PowerMem creates vector indexes for semantic search, but as the number of memories grows, index performance can degrade. OceanBase/SeekDB provides index-merge functionality that can optimize multiple indexes and improve query performance, especially for:
- Large-scale memory databases with millions of vectors
- Complex queries combining vector search and full-text search
- Multi-index scenarios (vector index + fulltext index + regular indexes)
- Frequent insert/update operations that fragment indexes
Pain points:
- Index fragmentation over time reduces search performance
- Multiple indexes (vector, fulltext, regular) are not optimized together
- No automatic index maintenance after bulk operations
- Query latency increases as data volume grows
Describe the solution you'd like
Add support for OceanBase/SeekDB index-merge functionality to optimize index performance
Describe alternatives you've considered
No response
Additional context
No response