logoalt Hacker News

direwolf20today at 2:28 AM1 replyview on HN

What about throughput? How many times can postgres commit per second on NVMe flash?


Replies

pclmulqdqtoday at 2:32 AM

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.

show 1 reply