From: | "cnliou" <cnliou(at)so-net(dot)net(dot)tw> |
---|---|
To: | "" <pgsql-performance(at)postgresql(dot)org> |
Subject: | pg_restore makes disk busy |
Date: | 2004-01-01 17:14:02 |
Message-ID: | 1072977242.87202.cnliou@so-net.net.tw |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Glover | 2004-01-02 03:34:01 | Very slow update + not using clustered index |
Previous Message | Vivek Khera | 2003-12-31 17:17:50 | Re: deferred foreign keys |