speeding up pg_dump?

Поиск

Список

Период

Сортировка

От
Тема	speeding up pg_dump?
Дата	26 декабря 2005 г. 22:48:02
Msg-id	005d01c60a8f$ef41dd30$6402a8c0@iwing обсуждение исходный текст
Ответы	Re: speeding up pg_dump?
Список	pgsql-novice

hi list

the pg_dump of our 2.45gb db takes an awfully long 45min during which db services come more or less to a hold.

this does not seem right to me. cpus and disks are basically idelling around. what other factors are involved in pg_dump?

here's our pg_dump command:

pg_dump -Fc -Z 2 -U postgres -f /backup/temp/mydb.db mydb

i tried to remove compression but that didn't help either - the server is more or less idle anyways.

i've noticed autovacuum continuing to vacuum tables during backup. might this be a problem?

any help speeding up the backup process is very appreciated!

- thomas

В списке pgsql-novice по дате отправления: