PostgreSQL Query Optimization by Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova 2021

I looked for books on optimizing SQL code in postgres since my queries in Labkey are slow - hoping to improve them by adapting the database schema and/or the queries I run. Labkey by default is using postgres, but the extra layer complicated things.

The book by Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova “PostgreSQL Query Optimization” published in 2021 is very readable, esp. in comparison to some other very theory heavy books on databases.

ISBN 978-1-4842-6885-8

It is published by Springer and available online via O’Reilly.