alter table on a large db

From: Zdravko Balorda <zdravko(dot)balorda(at)siix(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: alter table on a large db
Date: 2009-03-19 07:57:11
Message-ID: 49C1FAD7.3090003@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.
Is there any way to make it faster? I wonder what could possibly alter
table be doing all this time.

Regards, Zdravko.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleas Mantzios 2009-03-19 08:30:35 Re: alter table on a large db
Previous Message Srikanth 2009-03-18 16:02:29 Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps