Skip site navigation (1) Skip section navigation (2)

Re: backup and recovery

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: "Mark M(dot) Huber" <MHuber(at)VMdirect(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: backup and recovery
Date: 2004-03-22 14:18:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 <jeff(at)jefftrout(dot)com>

In response to

pgsql-admin by date

Next:From: Radu-Adrian PopescuDate: 2004-03-22 15:21:52
Subject: Re: Row data corruption under 7.3.5
Previous:From: alvaroDate: 2004-03-22 10:48:48
Subject: Re: SOS ---- Could you help me with postgresql.....????

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group