Re: large dbII to postgresql migration

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: large dbII to postgresql migration
Date: 2005-01-10 21:36:08
Message-ID: 20050110213608.GD67721@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)decibel(dot)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?"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-01-10 21:39:40 Re: large dbII to postgresql migration
Previous Message Brendan Jurd 2005-01-10 21:29:33 Re: Function for retreiving datatype