From: | Diogo de Oliveira Biazus <diogo(at)ikono(dot)com(dot)br> |
---|---|
To: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: feature request - adding columns with default value |
Date: | 2003-04-04 12:40:26 |
Message-ID: | 3E8D7D3A.50008@ikono.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Henrik Steffen wrote:
>hello,
>
>when doing an "alter table blub add column blah int2"
>and then issuing an "alter table blub alter column blah set default 0"
>I will always have to manually "update blub set blah=0" to initialize
>all existing records.... this is quite annoying while performing this
>update on a running database with 100 simultaneous clients accessing
>the database and about 443482 rows in the table.
>
>it takes about 10 minutes to perform this update, and for about 6 minutes
>all other updates to the table are in status "waiting", this leads to
>a very high load and all max_connection setting is reached soon
>(on a Dual-Xeon 2.4 GHz machine with 2 GB RAM)
>
>i would suggest to change the "alter table add column" function to
>adding a default value while adding the column if this is possible
>and if this minimizes "down-time".
>
>thank you
>
>
Maybe I'm wrong, but this feature was supported in 7.1,
and it was removed in 7.2.
If what I'm saying is true, I would like to know why was this feature
removed?
--
Diogo de Oliveira Biazus
diogo(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffrey D. Brower | 2003-04-04 12:45:29 | Re: [HACKERS] OSS database needed for testing |
Previous Message | rx | 2003-04-04 12:32:10 |