3 ms·
What’s the max throughout anyone’s got using Postgres as a queue? And on what spec machine? Could I conceivably put 200 messages per second through a Postgres
by vosper 3y ago
What’s the max throughout anyone’s got using Postgres as a queue? And on what spec machine?
Could I conceivably put 200 messages per second through a Postgres queue given a big enough RDS instance?
Wondering if we don’t really need to move to Kafka at work…
- colinchartier 3y agoPostgres can be tuned to 10k inserts per second, Kafka is definitely overkill for 200/s
- vosper 3y agoThanks! I will definitely look into this some more. M
- sorokod 3y agoWhen you read from the queue you do a "select for update",this uses up db resources (locks) . Is or isn't an issue depending on how many locks you want to take concurrently and for how long.