16 ms·

Can you clarify: Does the the initial construction (creation) of the index need to fit into RAM? Also, should one expect the reading via Postgres's buffer cac

by nh2 3y ago

Can you clarify: Does the the initial construction (creation) of the index need to fit into RAM? Also, should one expect the reading via Postgres's buffer cache to have better access patterns / need less memory / have other benefit vs having a non-Postgres HNSW index that's mmapped from disk?

raoufchebri 3y ago
The index doesn't need to fit in the shared buffers to be built, but you can speed the queries if you load it to memory