pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jesper Krogh <jesper@krogh.cc>
To: pgsql-performance@postgresql.org
Subject: Re: pg_dump performance?
Date: Fri, 6 Aug 2004 05:05:08 +0000 (UTC)
Message-ID: <cev3i4$jq8$1@sea.gmane.org> (raw)
References: <cesme0$fj9$1@sea.gmane.org>
	<41130D16.7030902@familyhealth.com.au>

I gmane.comp.db.postgresql.performance, skrev Christopher Kings-Lynne:
>  Is it the dump or the restore that's really slow?

Primarily the dump, it seems to be CPU-bound on the postmaster' process. 

No signs on IO-bottleneck when I try to monitor with iostat or vmstat

-- 
./Jesper Krogh, jesper@krogh.cc
Jabber ID: jesper@jabbernet.dk





view thread (10+ messages)  latest in thread

Message-ID: <cev3i4$jq8$1@sea.gmane.org>
Permalink:  ../cev3i4$jq8$1@sea.gmane.org/
Also on:    postgresql.org/message-id/cev3i4$jq8$1@sea.gmane.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jesper@krogh.cc
  Subject: Re: pg_dump performance?
  In-Reply-To: <cev3i4$jq8$1@sea.gmane.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