Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 25FDB1D7D623 for ; Fri, 20 Apr 2012 20:49:11 -0300 (ADT) Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SLNZZ-00078y-PA for pgsql-admin@postgresql.org; Fri, 20 Apr 2012 23:49:10 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1SLNZM-0004rM-1r for pgsql-admin@postgresql.org; Sat, 21 Apr 2012 01:48:52 +0200 Received: from ppp-188-174-11-162.dynamic.mnet-online.de ([188.174.11.162]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 21 Apr 2012 01:48:52 +0200 Received: from spam_eater by ppp-188-174-11-162.dynamic.mnet-online.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 21 Apr 2012 01:48:52 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Thomas Kellerer Subject: Re: Unending DB migration Date: Sat, 21 Apr 2012 01:48:50 +0200 Lines: 20 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: ppp-188-174-11-162.dynamic.mnet-online.de User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 In-Reply-To: X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/115 X-Sequence-Number: 39451 ЇЯЅHAÐ wrote on 17.04.2012 01:27: > Hi, > > We are trying to migrate from Postgres to Oracle, although our DB is gigantic > but we started on Mar 14th 2012 & its still running with an average of 400000 records per day > > How can we check what is going wrong. > Any memory leak, CPU issue or anything. If you are migrating *to* Oracle, then you should probably ask this question in an Oracle forum. Or is it the reading of the old data that is that slow? But anyway: without a lot more information about *how* you do the migration nobody will be able to help you Which program(s) do you use to migrate the data? What type of connection do you have between the two servers? What exactly is slow (inserting into Oracle, selecting from Postgres?)