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.