Re: Unending DB migration

Поиск
Список
Период
Сортировка
От Walter Hurry
Тема Re: Unending DB migration
Дата
Msg-id jmsr0s$t7l$1@dough.gmane.org
обсуждение исходный текст
Ответ на Unending DB migration  (ЇЯЅHAÐ <irshad.nazir@gmail.com>)
Список 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.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Alexander Fortin
Дата:
Сообщение: Re: pg_database_size() and actual disk space usage
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Unending DB migration