Tag: Postgres
-
Navigating Postgres- A guide to Identify bottlenecks

Have you been in a situation, where your database is becoming a bottleneck with growing data? API latency increases due to DB bottleneck?You are close to hitting the threshold of vertically scaling up your database? Well, I hope this guide will help you identify the bottlenecks and what you can do to mitigate it. Here…
-
Postgres from a Developer’s lens – Part 2

Case study A team was building a stock-keeping system which was responsible to manage stocks of products in a facility. The system should be able to decrement the stocks as part of order demand and give an visibility into which stock is available in which facility. As part of this system design, they team designed…
-
Postgres from a Developer Lens – Part 1

If you are currently on a team using Postgres as your primary database and using ORM, then there is a high chance that the developers miss out on some of the nuances of how Postgres executes the queries generated by the ORM and may end up discovering things in production. In this series, I will…
