From: Alvaro Herrera <alvherre@alvh.no-ip.org>
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 11:45:17 -0300
Message-ID: <20171125144517.wvsjlg2xeln5bood@alvherre.pgsql> (raw)
In-Reply-To: <CAF6DVKOW_zbyU2fH5RRqm-CddxmkfygYdaMs1EiUpXi10p01Zg@mail.gmail.com>
Debraj Manna wrote:
> Mark
>
> Is this time expected? I mean 17 minutes for 490 GB. I could not find any
> benchmark for pg_upgrade.
Maybe, or maybe not. Perhaps you can profile the process, to see if any
hot-spot becomes apparent, which can then be fixed.
Did you already test your applications with pg10?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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: alvherre@alvh.no-ip.org, 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: <20171125144517.wvsjlg2xeln5bood@alvherre.pgsql>
* 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