Vector Retrieval Topology & Latency Profiles
PostgreSQL pgvector (HNSW)
Colocates relational business state, transactional ACID row locks, and vector embeddings in a single audited cluster. Sub-5ms local p99 latency with zero WAN hops.
Data Sovereignty: 100% Air-Gapped Private VPC
Pinecone Serverless (Multi-Tenant Cloud)
Serverless operational convenience, but introduces 15ms–40ms WAN TLS latency and trans-border telemetry transmission exposure under DPDP Act 2023.
Latency Profile: 25ms+ (Subject to WAN Jitter)