PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

© Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova 2021

H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/978-1-4842-6885-8_8

8. Optimizing Data Modification

Henrietta Dombrovskaya¹  , Boris Novikov² and Anna Bailliekova³

(1)

Braviant Holdings, Chicago, IL, USA

(2)

HSE University, Saint Petersburg, Russia

(3)

Zendesk, Madison, WI, USA

 

Up to this point, the 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 in the database. That’s the subject of this chapter, which discusses how data manipulation affects performance and what can be improved.

What Is DML?

Any database system has ...