[jbellis]

It's been a while since I read the source to pgvector but at the time it was a straightforward HNSW implementation that implicitly assumes your index fits in page cache. Once that's not true, your search performance will fall off a cliff. Which in turn means your insert performance also hits a wall since each new vector requires a search.

I haven't seen any news that indicates this has changed, but by all means give it a try!

[hot_gril]

Thanks, I didn't know that. Last time I was dealing with these kinds of problems, pgvector didn't exist yet.