Thread: large dbII to postgresql migration

large dbII to postgresql migration

From
marcelo Cortez
Date:
hello to all

Soon time I am going to face a migration of a DBII
database our dear postgresql .
I will thank for any advice that can give me, in
addition this migration
will have 20 million records.
20 million record is to large instalation, exist some
tips for this type of facilities?
Tia .
Best regards

  Klingon








___________________________________________________________
250MB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar

Re: large dbII to postgresql migration

From
"Jim C. Nasby"
Date:
20 million rows isn't that large, unless you've got some really wide
rows. You shouldn't have any major issues, just make sure you are
vacuuming periodically.

On Mon, Jan 10, 2005 at 06:22:34PM -0300, marcelo Cortez wrote:
>
> hello to all
>
> Soon time I am going to face a migration of a DBII
> database our dear postgresql .
> I will thank for any advice that can give me, in
> addition this migration
> will have 20 million records.
> 20 million record is to large instalation, exist some
> tips for this type of facilities?
> Tia .
> Best regards
>
>   Klingon
>
>
>
>
>
>
>
>
> ___________________________________________________________
> 250MB gratis, Antivirus y Antispam
> Correo Yahoo!, el mejor correo web del mundo
> http://correo.yahoo.com.ar
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

Re: large dbII to postgresql migration

From
Scott Marlowe
Date:
On Mon, 2005-01-10 at 15:22, marcelo Cortez wrote:
> hello to all
>
> Soon time I am going to face a migration of a DBII
> database our dear postgresql .
> I will thank for any advice that can give me, in
> addition this migration
> will have 20 million records.
> 20 million record is to large instalation, exist some
> tips for this type of facilities?
> Tia .

My first recommendation would be the excellent tuning article hosted on
the varlena site:

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

My second recommendation is to read the docs thoroughly.