Postgres Pro
Downloads
Home   >   mailing lists

alter table on a large db - Mailing list pgsql-sql

From Zdravko Balorda
Subject alter table on a large db
Date
Msg-id 49C1FAD7.3090003@siix.com
Whole thread Raw
Responses Re: alter table on a large db  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: alter table on a large db  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Srikanth
Date:
Subject: Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps
Next
From: Achilleas Mantzios
Date:
Subject: Re: alter table on a large db