| From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | Zdravko Balorda <zdravko(dot)balorda(at)siix(dot)com> |
| Subject: | Re: alter table on a large db |
| Date: | 2009-03-19 08:30:35 |
| Message-ID: | 200903191030.36164.achill@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Στις Thursday 19 March 2009 09:57:11 ο/η Zdravko Balorda έγραψε:
>
> 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.
Which version of postgresql do you use?
Also you might consider editing the SQL dump to alter
the DDL statements prior to loading it in your db.
batch editing sed, awk, perl, could help you on that...
>
> Regards, Zdravko.
>
>
--
Achilleas Mantzios
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-03-19 11:17:14 | Re: alter table on a large db |
| Previous Message | Zdravko Balorda | 2009-03-19 07:57:11 | alter table on a large db |