53 discussions in the community
we're hitting a wall with database connections in rds postgres. we have around 50 microservice pods, and each maintains its own connection pool, maybe...
Dealing with hot partitions is a constant battle, especially when you have 'celebrity' users or entities that generate disproportionate traffic. We se...
we're currently doing zero-downtime schema migrations in postgres using a multi-deploy strategy: first, add a nullable column. then, deploy code that ...
we're building out a new internal monitoring and observability platform, and we need to store a massive amount of time-series data, roughly a million ...
we're dealing with a service that has a heavily normalized postgresql schema, and it's starting to cause significant performance headaches. a common u...
we're building out a new internal monitoring platform that needs to ingest around 1 million data points per minute from various services and infrastru...
we're currently trying to optimize a 'friends of friends' style query that's taking 10+ seconds with recursive cte's in postgres, and it's just not cu...
We're exploring CQRS for a new service but want to avoid the full complexity of event sourcing, at least initially. Our thought is to have a tradition...
we've developed a fairly robust process for zero-downtime schema migrations in PostgreSQL, which is critical for our always-on services. our typical f...
we're building out an internal monitoring platform and dealing with a pretty significant volume of time-series data roughly 1 million data points per ...
we're growing fast and our microservice count is now over 200, each maintaining its own database connection pool. we're frequently hitting postgresql ...
we're using read replicas extensively to scale our postgresql database, which has been great for offloading read traffic. the problem we're consistent...
we're building a feed service with dynamodb and running into the classic 'hot partition' problem for our celebrity users. our partition key is `userid...
I'm getting inconsistent feedback on how deep to go into database schema design during system design interviews. Some interviewers seem satisfied with...
we've been using soft deletes (an `is_deleted` flag) across most of our system for the past two years, and it's become a hidden source of complexity. ...
at work, we're currently running both postgresql and mongodb in our stack. postgres handles all the relational stuff, and mongodb is used for document...
we have several expensive aggregation queries that power dashboards and leaderboards, taking 5-10 seconds to run directly against our database. we nee...
We've been using soft deletes for years across most of our services at work, and honestly, the hidden complexities often outweigh the perceived simpli...
we have a number of expensive aggregation queries for dashboards and leaderboards that can take 5-10 seconds to run directly against the database. we'...
our main transactional database schema is highly normalized, which made a lot of sense initially for data integrity. however, we're now finding that c...
