| From: | Walter Hurry <walterhurry(at)lavabit(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Unending DB migration |
| Date: | 2012-04-20 23:21:00 |
| Message-ID: | jmsr0s$t7l$1@dough.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2012-04-20 23:48:50 | Re: Unending DB migration |
| Previous Message | Alexander Fortin | 2012-04-20 11:04:32 | Re: pg_database_size() and actual disk space usage |