pgvectorHNSW and IVFFlat index types are not replicated by logical replication. Indexes must be created independently on each node. See Maintaining pgvector.For very large datasets,
pgvectorcan become prohibitively slow in terms of index creation, query throughput (queries per second), and query latency. EDB is developingedb_vectorplus, a new vector search extension that coexists withpgvector, uses the samevectortype, and delivers higher query throughput and lower latency with a reduced CPU and memory footprint. Contact EDB for details.pgvectordoes not support parallel index builds prior to PostgreSQL 15.
Known limitations
Could this page be better? Report a problem or suggest an addition!