Re: large dbII to postgresql migration - Mailing list pgsql-general

From Scott Marlowe
Subject Re: large dbII to postgresql migration
Date
Msg-id 1105393180.10217.17.camel@state.g2switchworks.com
Whole thread Raw
In response to large dbII to postgresql migration  (marcelo Cortez <jmdc_marcelo@yahoo.com.ar>)
List 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.

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: large dbII to postgresql migration
Next
From: Michael Fuhr
Date:
Subject: Re: Function for retreiving datatype