tweak config file to increase pg_dump speed on pg 8.02 - Mailing list pgsql-admin

From D Kavan
Subject tweak config file to increase pg_dump speed on pg 8.02
Date
Msg-id BAY102-F9FDE95849B132BF9E9D5FD1C70@phx.gbl
Whole thread Raw
Responses Re: tweak config file to increase pg_dump speed on pg 8.02  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-admin
Hi,

It's taken 4 hours so far to dump a 3.5 GB database on a local disk.
How can I  increase performance?

We have the work memory & effective cach size are set to 16 MB.  Our
maintenance_work_memory is set to 256 MB.  Thanks for any help.
For the record we are running with dual 64-bit chips with 8 GB of memory.  I
have noticed that the only 6.5 % of the memory is being used for this and
the load is only at just over 1.

~DjK



pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: Re: Replication
Next
From: Chris Hoover
Date:
Subject: Help with rules