tweak config file to increase pg_dump speed on pg 8.02

From: "D Kavan" <bitsandbytes88(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: tweak config file to increase pg_dump speed on pg 8.02
Date: 2005-08-05 19:28:35
Message-ID: BAY102-F9FDE95849B132BF9E9D5FD1C70@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2005-08-05 19:29:28 Help with rules
Previous Message Jeff Frost 2005-08-05 16:10:57 Re: Replication