Happy new year! When performing "pg_restore -L list --disable-triggers -d db1 -v my_archive" , my hard disk for Linux box (with 96MB RAM) becomes extremely busy.
One example is that it takes more than 5 miniutes to restore for a table from 7800 rows. Each row has less than 117 bytes in length with total of 6 columns. Hence I think the amount of the to-restore data is not the cause of performance problem. The swap size is only 68K. Therefore, I don't think small amount of RAM is a problem, either. kjournald uses 2% CPU and postmaster uses 10%. CPU is about 95% idle. What makes the restore so slow? How do I speed it up? Regards, CN ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
