Comment 6 for bug 119780

Revision history for this message
Stuart Bishop (stub) wrote : Re: [Bug 119780] Re: GIN indexes cause some slow queries to fail entirely

Diogo Matsubara wrote:
> Stuart,
> do you plan to revert in the next rollout?
>

No - rebuilding the indexes will take 6 or 7 hours. It can be done live, but
will cause occasional OOPSes to users for occasional 5 minute periods.

We either need to:
 - Take launchpad down for a long time and do them all at once
 - Schedule regular downtime when stuff like this can be done.
   We can do it it 8 1 hour chunks instead of one long one
 - Do it live.

I'm not sure whose call it is on how we proceed.

--
Stuart Bishop <email address hidden> http://www.canonical.com/
Canonical Ltd. http://www.ubuntu.com/