Postgres is a great pub/sub and job server (2019)

Re:Postgres is a great pub/sub and job server (2019) by macksd on Friday December 17, 2021 @07:34PM (#29600141)

I think the point of interest was 32 cores to handle what sounds like 10 messages per second at most. That's not really a ton of throughput... It's certainly a valid point that an awful lot of uses cases don't need Twitter-scale firehoses or Google-size Hadoop clusters.

[ Parent | on HN ]

Re:Postgres is a great pub/sub and job server (2019) by colinchartier on Friday December 17, 2021 @07:36PM (#29600156)

Ah, the database does a lot more than just pub/sub - especially since the high traffic pub/sub goes through redis. I guess my point was that we never regretted setting up postgres as the "default job queue" and it never required much engineering work to maintain.

For an example, it handles stripe webhooks when users change their pricing tier - if you drop that message, users would be paying for something they wouldn't receive.

[ Parent | on HN ]

Re:Postgres is a great pub/sub and job server (2019) by rowanG077 on Monday December 20, 2021 @11:38AM (#29626816)

It said nothing about the distribution of traffic. It might well be thousands and thousands of pub sub messages at some point of the day and 0 for others.

[ Parent | on HN ]