pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
Date: 2012-10-19 21:44:05
Message-ID: CAP=oouFXfxbrvZ8FPq8QXSHJLcJtQ4i7RRjYeA_ow-OXTXvmQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message teyking2003 2012-10-20 00:16:31 Re: Auto Vacuum
Previous Message Scott Marlowe 2012-10-19 18:10:19 Re: Auto Vacuum