The Optimization Book Second Edition Is Here!

Today was the day - our PostgreSQL Query Optimization book was published! The book is currently available on Apress website, and if you are interested in the paper book, I believe that’s the fastest way to get it.

The e-book is available on both Apress and Amazon. I think that e-book makes much more sense because you can copy-paste examples, but I can’t disagree with those who told me that it’s difficult to sign an ebook. (Can you do this via DocuSign?!) 😃

As I have already said multiple times, I am grateful to everybody who reported multiple typos and inaccuracies and sometimes factual mistakes, and I hope that, thanks to our readers, we made the second edition much better! That does not mean that this edition is error-free, so we would be very thankful for all the critiques that will hopefully follow!

Special thanks to Hannu Krosing for his feedback on postgres_air database, to Egor Rogov for extensive comments and suggested corrections, to Jonathan Gennik, who came up with the idea of this book in early 2020, and to Tom Kincaid, who agreed to be our technical reviewer for the second time!

8 Comments

Filed under books

8 responses to “The Optimization Book Second Edition Is Here!

  1. Santeri

    Does the softcover version include a link to download the PDF version? I’d love to have the book in my bookshelf for browsing but for many situations the PDF is more convenient.

    • Hettie D.

      Unfortunately not, and I always recommend buying the ebook, because it’s easier to follow examples that way and also easier to find what you need when you look for something specific.

  2. Dmitriy S.

    Great news!

    What’s new in the second edition?

    Can you provide brief description about differences between first and second editions?

  3. Hettie D.

    Yes! Here are the differences:

    • There is a new version of postgres_air database. Not only the dates are shifted to 2023, but also an essential data cleansing was performed, so all examples are more realistic.
    • We used Postgres 15, which resulted in differences in both execution plans and performance in many cases
    • We added a chapter about configuration parameters (and why they are not as important as many people think)
    • Based on our readers’ feedback we rewrote a substantial number of paragraphs from clarity
    • A chapter about NORM is significantly rewritten because we now have a new and improved version of NORM
  4. Dmitriy S.

    Thank you. I really appretiate your work.

    Best reagrds to you and your co-authors. Many years ago I had a pleasure to speak with Boris Novikov on the PGDays conference. That time I did’t realize who he is. What a great man!

    Thank you once again. Be well.

  5. Hettie D.

    I will pass your message to him 🙂

Leave a comment