pg_restore makes disk busy

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

Browse pgsql-performance by date

  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