1 year ago

Grocery delivery startup Instacart recently switched https://aws.amazon.com/?utm_content=inline-mention‘ DynamoDB from the https://thenewstack.io/the-competitive-advantage-of-postgres/, and the engineering team is now sharing the schema design that reduced the number of billable writes-per-transaction by over half. The current system, Postgres running on Amazon EC2, was pushing its limits.

Instacart engineers recently decided that Postgres and Amazon EC2 instances were no longer working in their current form with the push message notifications.

“DynamoDB cost is based on the amount of data stored in the DynamoDB table, and the number of reads and writes to it,” Paldhe explained.

This means table storing is data write heavy with most of the loads being from inserts and updates.