We use pgvector which if you're already using postgres should be in the running for your use case.

I also like https://github.com/lancedb/lancedb