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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
