tweak config file to increase pg_dump speed on pg 8.02

Поиск
Список
Период
Сортировка
От D Kavan
Тема tweak config file to increase pg_dump speed on pg 8.02
Дата
Msg-id BAY102-F9FDE95849B132BF9E9D5FD1C70@phx.gbl
обсуждение исходный текст
Ответы Re: tweak config file to increase pg_dump speed on pg 8.02
Список 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 по дате отправления:

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: Replication
Следующее
От: Chris Hoover
Дата:
Сообщение: Help with rules