Comment by aurareturn

8 hours ago

Is that still a lot? Feels like a single 64-core, 256GB RDS instance with some caching should handle that fine. RDS has instances up to 192-core and 768GB.

Keep in mind they’re doing real-time logistics and messaging, as well as type-ahead search and managing ads and promotions

  • I think the real-time logistics is likely the thing taxes a Postgres database.

    Everything else seems normal DB CRUD that a single beefy instance with a few replicas should handle easily. Type ahead search is no doubt using a different service and not directly querying Postgres.