Company
Date Published
Author
Jim Knicely and Christiane Soto
Word count
1814
Language
English
Hacker News points
None

Summary

The logistics company aimed to improve the performance and resiliency of its electronic radio frequency system, which was critical for tracking and maintaining control over every SKU in its supply chain. The existing PostgreSQL database struggled with low-latency read and write operations, causing delays and frustration among users. To address this issue, the company adopted YugabyteDB, a distributed version of PostgreSQL that offered improved performance, resiliency, and high availability without requiring an expensive rewrite of the application. By leveraging features such as tablespaces, locality-optimized geo-partitioning, row-level security, and duplicate indexes, the company achieved significant improvements in workload performance, reducing response times to 43.7 milliseconds, while also ensuring data resiliency and high availability across its geographically distributed hybrid cloud deployment model.