On Wed, Oct 6, 2010 at 7:52 PM, Stuart Bishop <[email protected]> wrote: > On Mon, Oct 4, 2010 at 9:42 AM, Edwin Grubbs <[email protected]> > wrote: >> Hi Stuart, >> >> Do you have the staging db restore time that we use to announce the >> estimated downtime for the Launchpad release? > > This is a tricky one to estimate. There is a large change in the > pipeline that on staging took 3 hours last time it ran. However, this > patch should run much faster on the production hardware (the slowness > is rebuilding indexes on the 600 million rows of the BranchRevision > table). > > So based on this, I would guess up to 5 hours. > > However, we have also upgraded to PG 8.4. We should get a better > timing this weekend under PG 8.4.
5 hours downtime is -huge- right after Ubuntu releases. Lets roll that patch back and discuss alternate approaches, if the indication on Monday is that we're looking at more than an hours total downtime. -Rob _______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
