> None of the blogs mention that building an HNSW index on a few million vectors can consume 10+ GB of RAM or more

Speaking of "production" -- in what world is "10+ GB" a lot of RAM for a database server?

I have to agree: the author should definitely not use Postgres or pgvector in production...