From: Nic Xie <yudora111@...>
Date: 2009-01-20T05:19:46+09:00
Subject: Re: migration too slow?

I found I could not set it as a default. Because I have existing rows 
and I want all of them have the type explicitly.

To Robert, I only have this query running.

Nic

Nic Xie wrote:
> Thanks
> I use postgresql. I tried select * from pg_stat_activity. And it showed 
> current query is updating the x_logs.
> 
> But why it is so slow?
> 
> I will try to use it as a default value. It sounds good.
> 
> 
> 
> Denis Haskin wrote:
>> Maybe sorta OT for this list, but:
>> - assuming the db is MySQL, I'd do a SHOW PROCESSLIST from a MySQL
>> client (or use mytop) to see if the query is still running, if it's
>> maybe blocked by something else, or what... 8 hours for 100K rows?
>> Something's wrong...
>> - Since you're assigning the same value to all rows for this
>> newly-created column, perhaps setting a default value for the column
>> would be appropriate instead?
>> 
>>     add_column :x_logs, :x_type, :string, :default => 'blah'
>> 
>> 
>> dwh

-- 
Posted via http://www.ruby-forum.com/.