feature request - adding columns with default value
От | Henrik Steffen |
---|---|
Тема | feature request - adding columns with default value |
Дата | |
Msg-id | 027a01c2fa81$6ce38350$9800a8c0@henrik обсуждение исходный текст |
Ответы |
Re: feature request - adding columns with default value
Re: feature request - adding columns with default value Re: feature request - adding columns with default value Re: feature request - adding columns with default value Re: feature request - adding columns with default value |
Список | pgsql-general |
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 -- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am Steinkamp 7 - D-21684 Stade - Germany -------------------------------------------------------- http://www.topconcepts.com Tel. +49 4141 991230 mail: steffen@topconcepts.com Fax. +49 4141 991233 -------------------------------------------------------- 24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc) -------------------------------------------------------- Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de System-Partner gesucht: http://www.franchise.city-map.de -------------------------------------------------------- Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563 --------------------------------------------------------
В списке pgsql-general по дате отправления: