[ome-users] excessive time to upgrade database

[Carnë Draug]

Hello

I have been upgrading our omero installations this weekend and found
that the step to upgrade the database takes an excessive amount of
time.  It took more than 9 hours and caused a temporary >3x increase on
the database size (from 30GB to 100GB but at the end it was down to 64GB).

To be more exact, this is during the 5.0 to 5.1 upgrade, using the
"sql/psql/OMERO5.1__1/OMERO5.0__0.sql" database upgrade script.

I did notice that more than 8 hours were spent on a single step (I can't
tell which from the output of the upgrade but it was something that updated
50183812 rows).

I'm asking because the documentation states that this should execute quickly.
>From the upgrade instructions [1]:

    The 5.1 upgrade script should execute in a short time.

Could there be something wrong with our database?  Or is ours just abnormally
large?

Thank you
Carnë

[1] http://www.openmicroscopy.org/site/support/omero5.1/sysadmins/server-upgrade.html#run-the-upgrade-script