February 22nd, 2018 by depesz | Tags: , , , , | 4 comments »
Did it help? If yes - maybe you can help me?

Couple of times, in various places, I was asked: what is the benefit from upgrading to some_version.

So far, I just read release docs, and compiled list of what has changed.

But this is not necessarily simple – consider upgrade from 9.3.2 to 10.2. That's a lot of changes.

So, to be able to answer these questions faster in future, I created a site: Why upgrade PostgreSQL?.

Usage should be simple – pick from which version you want to upgrade, to which version you want to upgrade, and press gives me… button.

Hope you'll find it useful.

  1. 4 comments

  2. # Paco
    Feb 23, 2018

    Incalculable value.
    Thanks for such a great tool.

  3. # Joe
    Feb 23, 2018

    The “months/years worth of fixes” seems misleading. Upgrading from 9.4.15 to 9.6.7 says 3 months, ditto for to 10.2, 9.4.15 to 9.5.1 says -637 days! To 9.5.10 gives 0 days, although in reality 9.4.x to 9.5.x is about a year worth’s of development work.

  4. Feb 26, 2018


    worth of fixes is calculated based on release dates. if you have any idea how to give better estimates – I’ll gladly hear that.

  5. # Avinash Patil
    Jul 9, 2018

    Really useful information
    Thanks for Sharing

Leave a comment