launchpad-dev team mailing list archive

[Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>]

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.




-- 
Stuart Bishop <stuart@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/