zlacker

[parent] [thread] 3 comments
1. AtlasB+(OP)[view] [source] 2023-11-21 23:45:33
I thought the first rule of queues was never use a database as a queue.
replies(1): >>22c+zh
2. 22c+zh[view] [source] 2023-11-22 01:30:17
>>AtlasB+(OP)
The "problem" is that a database as a queue doesn't infinitely scale, but nothing infinitely scales. If you're starting to reach the limits of Postgres-as-a-queue then you've either done something very wrong or very right to get to that point.

It's probably more correct to say that the engineering effort required to make a Postgres-as-a-queue scale horizontally is a lot more than the engineering effort required to make a dedicated queueing service scale horizontally. The trade-off is that you're typically going to have to start scaling horizontally much sooner with your dedicated queuing service than with a Postgres database.

The argument for Postgres-as-a-queue is that you might be able to get to market much quicker, which can be significantly more important than how well you can scale down the track.

replies(1): >>AtlasB+YR1
◧◩
3. AtlasB+YR1[view] [source] [discussion] 2023-11-22 14:19:19
>>22c+zh
I thought Kafka could relatively infinitely scale
replies(1): >>22c+Qp2
◧◩◪
4. 22c+Qp2[view] [source] [discussion] 2023-11-22 16:45:53
>>AtlasB+YR1
I wouldn't categorise Kafka as a database.
[go to top]