On 2009-03-19, Zdravko Balorda <zdravko.balo...@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? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
