From: Jeff <threshar@torgo.978.org>
To: Mark M. Huber <MHuber@VMdirect.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: backup and recovery
Date: Mon, 22 Mar 2004 09:18:59 -0500
Message-ID: <DC617BF4-7C0B-11D8-ADE4-000D9366F0C4@torgo.978.org> (raw)
In-Reply-To: <C82819B1AE6E934A91FE8481153EB422A9E378@mail.co.vmdirect.com>
References: <C82819B1AE6E934A91FE8481153EB422A9E378@mail.co.vmdirect.com>
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@jefftrout.com>
http://www.jefftrout.com/http://www.stuarthamm.net/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: threshar@torgo.978.org, MHuber@VMdirect.com
Subject: Re: backup and recovery
In-Reply-To: <DC617BF4-7C0B-11D8-ADE4-000D9366F0C4@torgo.978.org>
References: <C82819B1AE6E934A91FE8481153EB422A9E378@mail.co.vmdirect.com> <DC617BF4-7C0B-11D8-ADE4-000D9366F0C4@torgo.978.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox