What type of latency requirements are you dealing with? (i.e. look up time, ingestion time)
Were you using postgres already or migrated data into it?
Were you using postgres already or migrated data into it?
I've ran a few tests on pg and retrieving 100 random indices from a billion-scale table -- without vectors, just a vanilla table with an int64 primary key -- easily took 700ms on beefy GCP instances. And that was without a vector index.
Entirely possibly my take was too cursory, would love to know what latencies you're getting bryan0!
Is there a write up of the analysis? Something seems very wrong with that taking 700ms
For future lookup queries on pgvector, we can almost always pre-filter on an index before the vector search.
yes, we use postgres pretty extensively already.