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

PG_DUMP Load

From: "Mike Rogers" <temp6453(at)hotmail(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: PG_DUMP Load
Date: 2002-04-19 14:35:39
Message-ID: OE60kYZv8M84X6wiMrr0000333d@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I seem to be having a problem with the pg_dump command on the Linux 2.2.x
operating system.  I have found that in doing a 425MB dump via TCP/IP over a
network, I receive up to 90.00 load on the dual P2 and dual P3 servers from a
start of 0.25 or so.  This is a gradule increase in load peaking up there, but
still this is completely unacceptable from a systems perspective.  Why is the
load going so high?  Why is this putting such stress on the system?  Why
doesn't this happen on load backups (which only peak up around 1.3 or so).
The server appears unresponsive during these times and processes time out and
fail.

Has anyone else has similar problems with pg_dump 7.1.3?
--
Mike


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-04-19 14:37:56
Subject: Re: Upgrade to 7.1.3
Previous:From: PATHHARA1Date: 2002-04-19 12:59:56
Subject: PostgreSql Installation

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