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(at)krogh(dot)cc
Jabber ID: jesper(at)jabbernet(dot)dk