Hear speakers from GitHub, Artsy, ZenDesk and many others as they discuss how their teams are optimizing the data layer to scale modern web and mobile apps. Reserve your seat now for this one day event on Sept. 28 in Seattle.
Constraints and indexes come at a cost: they add write overhead with each INSERT and UPDATE and they can take up significant amounts of space. Since they both enforce uniqueness, which should we prefer and how are they different?
A walk through a complex query which calculates run rates and percentage growth rate over time for an ‘as-a-service’ business. It breaks the query apart step by step and leverages a number of Postgres features such as CTEs and window functions.