From: Robert Klemme <shortcutter@...>
Date: 2009-01-20T04:28:59+09:00
Subject: Re: migration too slow?

On 19.01.2009 20:14, Nic Xie wrote:
> 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?

This can depend on a lot of factors.  Maybe too many SQL statements are 
executed or it is just a single UPDATE statement and the transaction 
needs too much storage, maybe the DB's setup is not appropriate for this 
type of update etc.

Kind regards

	robert

-- 
remember.guy do |as, often| as.you_can - without end