On 2009-03-19, Zdravko Balorda <zdravko.balorda@siix.com> wrote:
>
> Hi,
>
> I need to make some ALTER TABLEs. It takes about 30min to copy
> this quite large databse, bat several ours to run a bunch of ALTER
> TABLE statements.
which do you prefer 30 minutes down-time to reload the database or a
few hours wait to update it live.
> Is there any way to make it faster? I wonder what could possibly alter
> table be doing all this time.
drop and reload the table?