X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B5334D1BB71 for ; Thu, 1 Jan 2004 17:14:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24547-04 for ; Thu, 1 Jan 2004 13:14:10 -0400 (AST) Received: from mail2000-4.so-net.net.tw (mail2000-4.so-net.net.tw [61.64.127.20]) by svr1.postgresql.org (Postfix) with SMTP id 70590D1B498 for ; Thu, 1 Jan 2004 13:14:08 -0400 (AST) Received: from 10.1.9.28 by mail2000-4.so-net.net.tw with Mail2000 ESMTP Server V2.71S(31478:0:AUTH_RELAY) Fri, 02 Jan 2004 01:14:06 +0800 (CST); (envelope-from ) Received: By OpenMail Mailer;Fri, 02 Jan 2004 01:14:02 +0800 (CST) From: "cnliou" Reply-To: cnliou@so-net.net.tw Subject: pg_restore makes disk busy Message-ID: <1072977242.87202.cnliou@so-net.net.tw> To: "" Date: Fri, 02 Jan 2004 01:14:02 +0800 (CST) MIME-Version: 1.0 Content-Type: text/plain X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200401/1 X-Sequence-Number: 5176 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