The file is just over 4 gig. -----Original Message----- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 6:19 AM To: Mark M. Huber Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] backup and recovery
On Mar 18, 2004, at 3:08 PM, Mark M. Huber wrote: > It seams that any backup and recovery sucks. My main db backup takes > over two hours to complete and 13 hours to recover what am I doing > wrong? Any hints?ideas? Recommendations? > > Increasing sort_mem dramatically (say, 128M) will greatly speed things up - especially with foriegn key creation and index creation (Those two things are what takes the longest in a PG restore). Be sure to turn it back down to something normal after the store (If you didn't change it on a single session) However a 500k row table is not terribly big.. How big is the dump in terms of MB? -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
