Hacker News new | past | comments | ask | show | jobs | submit
tomtomtom777 | on: PgDog is funded and coming to a database near you
100k(s) orders per minute is several orders of magnitude more than realistic. Amazon does 20k orders per minute.

Instacart doesn't need "100,000s of grocery delivery orders per minute".

There must be some 0s added for the sake of the story.

true_religion | parent | next
According their 2026 Q1 filing they do about 90 million orders per quarter which is about 12 orders per second, 720 orders per minute.

It might make 100k row level changes per minute, but that’s a different metric.

https://www.sec.gov/Archives/edgar/data/1579091/000157909126...

loading story #48481471
loading story #48481497
loading story #48486388
loading story #48483088
dotancohen | parent | next
Amazon does 20k peak, or 20k average? Website visitor peaks could easily be two orders of magnitude higher traffic than average for a few minutes.
aurareturn | root | parent | next
I worked at a company that had billions of views per year on a single big Postgres instance. Extremely read heavy with many queries needed for a page load. You can cache a lot of things.
dotancohen | root | parent | next
Yes, but that's not a shopping cart, or a checkout workflow, nor a web store with heavy analytics.
aurareturn | root | parent
It was one of the top real estate portals in the world. A lot of geolocation searches. New search every time someone moves the map. A ton of data sent to the client. Analytics in every page view.

No clue how a shopping cart or checkout flow would drastically increase database load. It should just be basic CRUD. Building a shopping cart is something every student makes. Pages in a web store can be cached relatively easily since items won't change often.

A primary DB with a few replicas and caching can go a really long way.

loading story #48483502
loading story #48484260
inigyou | root | parent
Scaling (asynchronous) reads is much easier than scaling writes.
| root | parent
{"deleted":true,"id":48481757,"parent":48480975,"time":1781121480,"type":"comment"}
nijave | parent
That doesn't necessarily mean _new_ orders per minute. Their app or website could poll for updates every 15 seconds

Could just be looking at the "orders" endpoint in their app which might also include incremental updates as shoppers get items from the store. It's a fairly ambiguous statement