pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



Message-ID: <1072977242.87202.cnliou@so-net.net.tw>
Permalink:  ../1072977242.87202.cnliou@so-net.net.tw/
Also on:    postgresql.org/message-id/1072977242.87202.cnliou@so-net.net.tw

 · 

reply

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