logoalt Hacker News

melon_tsuitoday at 2:28 PM1 replyview on HN

2M qps in production is legit. Curious how much RAM and CPU that takes on average per deployment though


Replies

levkktoday at 2:52 PM

Depends. Only pooling, very little. Load balancing/sharding needs to parse queries, so a bit more. Could go up to a GB per pod, sometimes more if you have a lot of unique SQL queries (unique by text, not by parameters). We cache query ASTs to avoid parsing them on each request - that's the bulk of memory usage.

show 1 reply