Description
Review the current pgvector/Lakebase table schema and optimize for production workloads.
Scope
- Analyze current table structure, indexes, and column types
- Evaluate pgvector index strategy (IVFFlat vs HNSW)
- Review query patterns and add missing indexes
- Assess partition strategy for multi-gateway cache isolation
- Benchmark cache lookup latency
Description
Review the current pgvector/Lakebase table schema and optimize for production workloads.
Scope