© 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_8

8. Optimizing Data Modification

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

Up to this point, our focus has been on optimizing queries, which means that only data retrieval has been covered. We haven’t touched on anything related to data manipulation, that is, updating, removing, or adding records. This is the subject of this chapter, which discusses how data manipulation affects performance and how performance for these operations ...

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.