Is it the dump or the restore that's really slow?
Chris
Jesper Krogh wrote:
> 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
>