© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024
H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/979-8-8688-0069-6_9

9. Design Matters

Henrietta Dombrovskaya1  , Boris Novikov2 and Anna Bailliekova3
(1)
DRW Holdings, Chicago, IL, USA
(2)
Database expert, Helsinki, Finland
(3)
UrbanFootprint, Milwaukee, Wisconsin, USA
 

In the Introduction, we noted that optimization begins during requirements gathering and design. To be precise, it starts with system design, including the database design, but it is impossible to come up with the right design unless we invest time in gathering information about the objects that should be present in the database. In this chapter, we will discuss a variety ...

Get PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.