I have used RedisSearch with chatgtp-retrieval-plugin and several megabytes of documents. It works well. And setting it up is just a single docker run command away ... so I don't see myself using anything else for local development. LangChain also has support for it.

Answering my own question with a pull-quote from a post written and linked by @shreyans:

"Redis can be a simple store, either with the embedding as the entire value, or as a value in a hash along with other metadata, or their newer vector search functions. Overall this works, but is more work than necessary, and not ideal for this use case."

https://maven.com/blog/embeddings