Postgres pgvector Index

[itsfrankjames]

Hey team,

I need to back my route embeddings with an existing Postgres instance so I'd like to submit an Index implementation for Postgres pgvector.
I plan to use Psycopg 3 for the Postgres adaptor.

I've read the base and existing implementation and the process looks straightforward.

Let me know if this is worthwhile making a PR for, or it there's any considerations I should be aware of.

[jamescalam]

@itsfrankjames go for it, I imagine this will be useful for a lot of teams so it'd be a very welcome addition

[jamescalam]

@itsfrankjames we did some more work on the PG integration, it is now live in v0.0.56 — docs on usage are here https://github.com/aurelio-labs/semantic-router/tree/main/docs/indexes/postgres

Thanks for the PR!