On Thu, Oct 3, 2019 at 10:31 AM Jason Ralph
<jralph@affinitysolutions.com> wrote:
> The end of month process that we run at my company was a pg_dump and pg_restore of 3 tables, these tables are around
~(400GB)each. The entire process on pg93 took 29 hours.
>
> The index creation portion of the restore on the target pg9.3 database took:
> 5) time: -15 hours -4 minute ((-54264 % 60)) seconds
>
> The index creation of the restore on the target db after pg11 upgrade on source and target took:
> 5) time: -5 hours -7 minute ((-18434 % 60)) seconds
>
> We saved 10 hours!!
The sort code received many improvements over the years, really
starting in 9.5, and continuing in 9.6, 10 and 11. FWIW, I think that
that was probably the biggest factor here. Though parallel CREATE
INDEX will have helped as well.
--
Peter Geoghegan