launchpad-dev team mailing list archive

[Robert Collins <robert.collins@xxxxxxxxxxxxx>]

On Wed, Oct 6, 2010 at 7:52 PM, Stuart Bishop
<stuart.bishop@xxxxxxxxxxxxx> wrote:
> On Mon, Oct 4, 2010 at 9:42 AM, Edwin Grubbs <edwin.grubbs@xxxxxxxxxxxxx> 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