This article discusses vector retrieval and introduces the combination of PostgreSQL postgres_fdw and vector plug-ins.
This article discusses how PolarDB addresses the performance problems in FPW.