Kafka is Fast – I'll use Postgres

Re:Kafka is Fast – I'll use Postgres by sgarland on Thursday October 30, 2025 @08:05AM (#45759115)

This is so accurate. I’ve looked in wonder at how someone is maxing out an r6i.32xlarge MySQL DB, when I have ran 4x the workload on an r6i.12xlarge.

Schema design and query design will make or break your app’s ability to scale without skyrocketing the bill, it’s as simple as that.

[ Parent | on HN ]

Re:Kafka is Fast – I'll use Postgres by notpaulgraham on Thursday October 30, 2025 @11:05AM (#45760856)

any blogs/books you'd recommend on schema & query design? it honestly surprises me that these coding-focused models can't look at a schema; look at how data is being queried; reason about the use case for the data; and help prioritize solving for the most likely bottlenecks to scaling the underlying data services.

[ Parent | on HN ]

Re:Kafka is Fast – I'll use Postgres by LikesPwsh on Friday October 31, 2025 @04:37AM (#45769649)

https://learn.microsoft.com/en-us/sql/relational-databases/s...

This one is a classic for MSSQL, most of it is applicable on postgres.

[ Parent | on HN ]

Re:Kafka is Fast – I'll use Postgres by arcturii on Friday October 31, 2025 @10:12AM (#45772186)

I like http://www.redbook.io/

[ Parent | on HN ]