From: Nic Xie <yudora111@...>
Date: 2009-01-20T04:14:40+09:00
Subject: Re: migration too slow?

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/.