From: cnliou <cnliou@so-net.net.tw>
To: pgsql-performance@postgresql.org
Subject: pg_restore makes disk busy
Date: Fri, 02 Jan 2004 01:14:02 +0800 (CST)
Message-ID: <1072977242.87202.cnliou@so-net.net.tw> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cnliou@so-net.net.tw
Subject: Re: pg_restore makes disk busy
In-Reply-To: <1072977242.87202.cnliou@so-net.net.tw>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox