Entire cycle in sub-second. I agree that it depends on many factors but as per the system, we are looking subsecond from ingestion of data from client to availability of data for query.
I see. I would suggest you explore the following:
1. CitusDB (an offshoot of postgres with high ingestion rate, cloudflare used it)
2. Druid.io (popular in ad-tech)
3. Linkedin Pinot (uber uses it for similar use-cases)
4. memSQL (used in ad-tech)
Thanks for the pointers but I am planning to revolve more around AWS ecosystem so that I have less ops burden of managing servers + regionalization becomes easy.