pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Debraj Manna <subharaj.manna@gmail.com>
Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Faster way of upgrading postgresql to 10 from 9.5
Date: Sat, 25 Nov 2017 10:19:36 -0500
Message-ID: <776.1511623176@sss.pgh.pa.us> (raw)
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>

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




view thread (17+ messages)  latest in thread

Message-ID: <776.1511623176@sss.pgh.pa.us>
Permalink:  ../776.1511623176@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/776.1511623176@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, subharaj.manna@gmail.com, mark.kirkwood@catalyst.net.nz, aaguayo@opensysperu.com
  Subject: Re: Faster way of upgrading postgresql to 10 from 9.5
  In-Reply-To: <776.1511623176@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox