At 1M embeddings I'd think pgvector would do just fine assuming a sufficiently powerful database.