Re: alter table on a large db

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: alter table on a large db
Дата
Msg-id dcc563d10903190417g3189d87fj8e7023ee1adbcbae@mail.gmail.com
обсуждение исходный текст
Ответ на alter table on a large db  (Zdravko Balorda <zdravko.balorda@siix.com>)
Список pgsql-sql
On Thu, Mar 19, 2009 at 1:57 AM, Zdravko Balorda
<zdravko.balorda@siix.com> wrote:
>
> 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 alter table statements are you running in particular?  Most
alter table stuff runs pretty quickly, like adding a column and such.
Just wondering.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: alter table on a large db
Следующее
От: Emi Lu
Дата:
Сообщение: Re: alter column from varchar(32) to varchar(255) without view re-creation