PostgreSQL Performance for Application Developers - Because there is no Magic Button
Developing an application and stress testing it is great. But as the app goes into production and begins to scale, more often than not, we begin to encounter situations that we haven't thought about during the design process. This could be related to new use cases, disruptions in technology, or the sheer scale/volume of data and users.
This is especially true for databases, more so because of the increasing trend of application developers and architects defining the technology stack - i.e. non-experts of databases making database decisions. Nothing wrong with it, especially as it speeds up the process of development and go-to-market.
This talk focuses on such instances in order to guide developers of a few key items to be mindful of when designing and scaling applications using PostgreSQL.