pg_dump performance?

Поиск
Список
Период
Сортировка
От Jesper Krogh
Тема pg_dump performance?
Дата
Msg-id cesme0$fj9$1@sea.gmane.org
обсуждение исходный текст
Ответы Re: pg_dump performance?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance
I have a database that I should migrate from 7.3 -> 7.4.3 but pg_dump |
psql seems to take forever. (Several hours) Is there anything that can I
do to speed it up?

The databse is primary a table with 300.000 records of about 200Kbytes
each. ~ 60 GB.

This is becoming an issue with the daily backup too.. (running pg_dump
over night )

Jesper

--
./Jesper Krogh, jesper@krogh.cc
Jabber ID: jesper@jabbernet.dk


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

Предыдущее
От: "Mischa Sandberg"
Дата:
Сообщение: Re: my boss want to migrate to ORACLE
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: pg_dump performance?