test: Test pgvecto.rs FDW against postgres with pgvector

tensorchord / pgvecto.rs

Scalable, Low-latency and Hybrid-enabled Vector Search in Postgres. Revolutionize Vector Search, not Database.

https://docs.pgvecto.rs/getting-started/overview.html

Apache License 2.0

1.59k stars 62 forks source link

test: Test pgvecto.rs FDW against postgres with pgvector #421

Closed VoVAllen closed 4 months ago

VoVAllen commented 4 months ago

Check whether pgvecto.rs can be connected to AWS RDS/supabase (postgres without pgvecto.rs) through FDW.

gaocegege commented 4 months ago

Ref #354

gaocegege commented 4 months ago

Could you please illustrate more about the issue? e.g. How to check it.

VoVAllen commented 4 months ago

Start one postgres with pgvector, and check whether it can use FDW to connect to pgvecto.rs instance. Need to check whether create index/select/insert operation works.

And finally to check the performance on AWS RDS/supabase, and run some real world workload to check whether everything works as expected.