`pgvector` backend

[illeatmyhat]

Potential integration options often have a strong preference for using postgres for everything, making pgvector a supported backend a high priority.

[illeatmyhat]

@gaodan-fang do you think this can be closed?

[gaodan-fang]

yes, go ahead