On Mon, Dec 19, 2005 at 03:11:04PM -0500, Chris Hoover wrote: > I have upped the following parameters to help speed up our > conversions, is there any issues leaving them set to these values > after our conversion to 8.1? > maintenance_work_mem to 1GB (1048576) > checkpoint_segements to 256 > checkpoint_timeout to 1800 seconds (30 minutes)
During the conversion you might want to turn fsync off. AFAIK it's safe to do that so long as you get a clean shutdown and then do a sync; sync; sync Don't run that way in production though... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
