Hacker News new | ask | show | jobs
by direwolf20 129 days ago
What about throughput? How many times can postgres commit per second on NVMe flash?
1 comments

You can do about 100k commits per second, but this also partly depends on the CPU you attach to it. It also varies with how complicated the queries are.

With 100 million DAU, you're often going to have problems with this rate unless you batch your commits. With 100 million user accounts (or MAU), you may be fine.

That should be enough for most apps.