pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
9+ messages / 2 participants
[nested] [flat]

* pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-10-19 21:44  Lonni J Friedman <netllama@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Lonni J Friedman @ 2012-10-19 21:44 UTC (permalink / raw)
  To: pgsql-admin

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.

thanks




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 18:42  Bruce Momjian <bruce@momjian.us>
  parent: Lonni J Friedman <netllama@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Bruce Momjian @ 2012-11-07 18:42 UTC (permalink / raw)
  To: Lonni J Friedman <netllama@gmail.com>; +Cc: pgsql-admin

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.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 18:44  Lonni J Friedman <netllama@gmail.com>
  parent: Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 9+ messages in thread

From: Lonni J Friedman @ 2012-11-07 18:44 UTC (permalink / raw)
  To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 20:59  Bruce Momjian <bruce@momjian.us>
  parent: Lonni J Friedman <netllama@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Bruce Momjian @ 2012-11-07 20:59 UTC (permalink / raw)
  To: Lonni J Friedman <netllama@gmail.com>; +Cc: pgsql-admin

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?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 21:06  Lonni J Friedman <netllama@gmail.com>
  parent: Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 9+ messages in thread

From: Lonni J Friedman @ 2012-11-07 21:06 UTC (permalink / raw)
  To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 21:07  Bruce Momjian <bruce@momjian.us>
  parent: Lonni J Friedman <netllama@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Bruce Momjian @ 2012-11-07 21:07 UTC (permalink / raw)
  To: Lonni J Friedman <netllama@gmail.com>; +Cc: pgsql-admin

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. 

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 21:09  Lonni J Friedman <netllama@gmail.com>
  parent: Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 9+ messages in thread

From: Lonni J Friedman @ 2012-11-07 21:09 UTC (permalink / raw)
  To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 21:15  Bruce Momjian <bruce@momjian.us>
  parent: Lonni J Friedman <netllama@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Bruce Momjian @ 2012-11-07 21:15 UTC (permalink / raw)
  To: Lonni J Friedman <netllama@gmail.com>; +Cc: pgsql-admin

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. +




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
@ 2012-11-07 21:17  Lonni J Friedman <netllama@gmail.com>
  parent: Bruce Momjian <bruce@momjian.us>
  0 siblings, 0 replies; 9+ messages in thread

From: Lonni J Friedman @ 2012-11-07 21:17 UTC (permalink / raw)
  To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin

On Wed, Nov 7, 2012 at 1:15 PM, Bruce Momjian <bruce@momjian.us> wrote:
> 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?

It never hung, it just took a very long time.  This was over 2 weeks
ago, and I'm afraid that I don't have the output any longer.  Once I
was satisfied that the upgrade was successful, and 9.2 was working ok,
I deleted the log and 9.1 bits.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2012-11-07 21:17 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-19 21:44 pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)? Lonni J Friedman <netllama@gmail.com>
2012-11-07 18:42 ` Bruce Momjian <bruce@momjian.us>
2012-11-07 18:44   ` Lonni J Friedman <netllama@gmail.com>
2012-11-07 20:59     ` Bruce Momjian <bruce@momjian.us>
2012-11-07 21:06       ` Lonni J Friedman <netllama@gmail.com>
2012-11-07 21:07         ` Bruce Momjian <bruce@momjian.us>
2012-11-07 21:09           ` Lonni J Friedman <netllama@gmail.com>
2012-11-07 21:15             ` Bruce Momjian <bruce@momjian.us>
2012-11-07 21:17               ` Lonni J Friedman <netllama@gmail.com>

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