From: Tom Lane <tgl@sss.pgh.pa.us>
To: Debraj Manna <subharaj.manna@gmail.com>
cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>,
        Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>,
        pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Faster way of upgrading postgresql to 10 from 9.5
In-reply-to: 
 <CAF6DVKOW_zbyU2fH5RRqm-CddxmkfygYdaMs1EiUpXi10p01Zg@mail.gmail.com>
References: 
 <CAF6DVKOZOqFPLFcnmxF6PU7j7NMkQN90jkb8af-gTRAyfZKZ_w@mail.gmail.com>
 <jdhahc12n02hggumet17qaok.1511582685139@email.android.com>
 <CAF6DVKNrE86fKEJhw4YCs5erekKCTJXnq5sWHc_C5wR5XJo6Rg@mail.gmail.com>
 <hbcp5fi9i6fpjd66b6r2a8p7.1511586597413@email.android.com>
 <CAF6DVKPf7++_RGYY5xDNyhXhix6RYeNOT2VT_C0AC+Cs=PbWDA@mail.gmail.com>
 <4d397bf0-14c3-2bf8-bee6-c023a654b7ef@catalyst.net.nz>
 <CAF6DVKPHbwf+B-Q_e+UoZgbf2ht3vMV1qa2GgnuED_pRR+5LBw@mail.gmail.com>
 <a1a12fbe-f5aa-542f-77f2-5220b24d917c@catalyst.net.nz>
 <CAF6DVKOW_zbyU2fH5RRqm-CddxmkfygYdaMs1EiUpXi10p01Zg@mail.gmail.com>
Comments: In-reply-to Debraj Manna <subharaj.manna@gmail.com>
	message dated "Sat, 25 Nov 2017 11:48:27 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <775.1511623176.1@sss.pgh.pa.us>
Date: Sat, 25 Nov 2017 10:19:36 -0500
Message-ID: <776.1511623176@sss.pgh.pa.us>
Precedence: bulk

Debraj Manna <subharaj.manna@gmail.com> writes:
> Is this time expected? I mean 17 minutes for 490 GB. I could not find any
> benchmark for pg_upgrade.

It seems awfully slow, if you're using -k.  That switch should remove any
dependency on the data size, but what remains is the number of SQL objects
(databases, tables, functions, etc).  If you've got tens or hundreds of
thousands of those, maybe this would be a reasonable time.

As Alvaro said, it's possible that you're hitting some fixable bottleneck;
but to identify what that is we'd need some profiling information.

			regards, tom lane