pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/




view thread (21+ messages)  latest in thread

Message-ID: <DC617BF4-7C0B-11D8-ADE4-000D9366F0C4@torgo.978.org>
Permalink:  ../DC617BF4-7C0B-11D8-ADE4-000D9366F0C4@torgo.978.org/
Also on:    postgresql.org/message-id/DC617BF4-7C0B-11D8-ADE4-000D9366F0C4@torgo.978.org

 · 

reply

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