From: Bruce Momjian <bruce@momjian.us>
To: Lonni J Friedman <netllama@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
Date: Wed, 7 Nov 2012 16:15:18 -0500
Message-ID: <20121107211518.GH26215@momjian.us> (raw)
In-Reply-To: <CAP=oouEJp+fEHLou4gAmUzRXG=9T1t46gXx-vCS1hcSYVW0PAQ@mail.gmail.com>
References: <CAP=oouFXfxbrvZ8FPq8QXSHJLcJtQ4i7RRjYeA_ow-OXTXvmQg@mail.gmail.com>
<20121107184232.GB19163@momjian.us>
<CAP=oouG8VKubS78DSRBNXyY463VhtaQhu64kNRiHDQEMt1c0mA@mail.gmail.com>
<20121107205950.GE26215@momjian.us>
<CAP=oouG70Jdu3d8jYEvA4T0_MZnzmV+Zqe2nt0kz63HvZ6UJBQ@mail.gmail.com>
<20121107210703.GG26215@momjian.us>
<CAP=oouEJp+fEHLou4gAmUzRXG=9T1t46gXx-vCS1hcSYVW0PAQ@mail.gmail.com>
On Wed, Nov 7, 2012 at 01:09:19PM -0800, Lonni J Friedman wrote:
> On Wed, Nov 7, 2012 at 1:07 PM, Bruce Momjian <bruce@momjian.us> wrote:
> > On Wed, Nov 7, 2012 at 01:06:19PM -0800, Lonni J Friedman wrote:
> >> On Wed, Nov 7, 2012 at 12:59 PM, Bruce Momjian <bruce@momjian.us> wrote:
> >> > On Wed, Nov 7, 2012 at 10:44:12AM -0800, Lonni J Friedman wrote:
> >> >> On Wed, Nov 7, 2012 at 10:42 AM, Bruce Momjian <bruce@momjian.us> wrote:
> >> >> > On Fri, Oct 19, 2012 at 02:44:05PM -0700, Lonni J Friedman wrote:
> >> >> >> Greetings,
> >> >> >> I'm in the process of planning for a production upgrade from 9.1.6 to
> >> >> >> 9.2.x (all Linux-x86-64). In my staging environment (which has the
> >> >> >> same versions), I kicked off pg_upgrade about 5 hours ago, and its
> >> >> >> still not done. It is making progress, so I don't think anything has
> >> >> >> gone wrong, beyond it taking much longer than anticipated.
> >> >> >>
> >> >> >> When I used pg_upgrade to go from 9.0.x to 9.1.x, it finished in just
> >> >> >> under an hour. There is admittedly about three times as much data (in
> >> >> >> terms of disk usage) now than when I upgraded from 9.0.x. Would that
> >> >> >> explain the increased time needed to do the upgrade? Or is there
> >> >> >> something about the upgrade to 9.2.x that requires a lot more time?
> >> >> >>
> >> >> >> I'm trying to understand if what I'm seeing is expected, normal
> >> >> >> behavior, or if something might not be right.
> >> >> >
> >> >> > Odd. How many object/tables do you have? I have just patched 9.2 to
> >> >> > improve upgrades for clusters with many objects.
> >> >>
> >> >> about 5000 tables spread across 5 databases.
> >> >
> >> > That should not take very long. Are you using link mode?
> >>
> >> Nope. The command that I used was:
> >> pg_upgrade -b /usr/pgsql-9.1/bin -B /usr/pgsql-9.2/bin -d
> >> /var/lib/pgsql/9.1/data -D /var/lib/pgsql/9.2/data
> >
> > Well, it must then copy all the data from old to new cluster --- that
> > could take a while.
>
> I guess so, but its hard to tell. It was sitting for quite a while
> with no output.
It should spin through the file names as they are copied. What was the
last output line before it hung?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
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: bruce@momjian.us, netllama@gmail.com
Subject: Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
In-Reply-To: <20121107211518.GH26215@momjian.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