From: Walter Hurry <walterhurry@lavabit.com>
To: pgsql-admin@postgresql.org
Subject: Re: Unending DB migration
Date: Fri, 20 Apr 2012 23:21:00 +0000 (UTC)
Message-ID: <jmsr0s$t7l$1@dough.gmane.org> (raw)
References: <CAK1h3NoEESan7pOyHukyZSM9oL1S6Y0w=qVqnBP-YWDj2pVqWQ@mail.gmail.com>
On Mon, 16 Apr 2012 16:27:38 -0700, ЇЯЅHAÐ wrote:
> 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
400,000? That's pathetic. Why didn't you just use Postgres's "copy to"
CSVS and then Oracle's SQL*Loader?
How big is "gigantic"?
> How can we check what is going wrong.
> Any memory leak, CPU issue or anything.
>
> Please help me fix it Hi,<br><br>We are trying to migrate from Postgres
> to Oracle, although our DB is gigantic<br>but we started on Mar 14th
> 2012 & its still running with an average of 400000 records per
> day<br><br>How can we check what is going wrong.<br>
> Any memory leak, CPU issue or anything.<br><br clear="all">Please help
> me fix it<br><br><br>
Please don't post in HTML.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: walterhurry@lavabit.com
Subject: Re: Unending DB migration
In-Reply-To: <jmsr0s$t7l$1@dough.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox