Re: large dbII to postgresql migration

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
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:39:40
Message-ID: 1105393180.10217.17.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-01-10 22:20:38 Re: Function for retreiving datatype
Previous Message Jim C. Nasby 2005-01-10 21:36:08 Re: large dbII to postgresql migration