X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C92EF536C9 for ; Tue, 12 Apr 2005 06:45:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16109-04 for ; Tue, 12 Apr 2005 09:45:00 +0000 (GMT) Received: from mail3.cc.huji.ac.il (mail3.cc.huji.ac.il [132.64.1.21]) by svr1.postgresql.org (Postfix) with ESMTP id DA59F52958 for ; Tue, 12 Apr 2005 06:44:58 -0300 (ADT) Received: from mail3.cc.huji.ac.il (localhost [127.0.0.1]) by mail3.cc.huji.ac.il (Postfix) with SMTP id 42E6341C06; Tue, 12 Apr 2005 12:44:57 +0300 (IDT) Received: by mail3.cc.huji.ac.il (Postfix, from userid 31998) id 36B6C41C08; Tue, 12 Apr 2005 12:44:57 +0300 (IDT) Received: from [132.64.52.127] (evegeni.mm.huji.ac.il [132.64.52.127]) by mail3.cc.huji.ac.il (Postfix) with ESMTP id B88A641C06 for ; Tue, 12 Apr 2005 12:44:56 +0300 (IDT) Message-ID: <425B98BF.5090400@mail.jct.ac.il> Date: Tue, 12 Apr 2005 12:45:35 +0300 From: Tsirkin Evgeny User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: db restore eats too much memory Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus: scanned by VAMS 2005 version 8.673 from Mon Apr 11 18:21:03 2005 CEST X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/149 X-Sequence-Number: 17162 Hi! I am trying to copy my db from one machine to another . However since my dump file is pretty big while trying to restore on the target one the machine just "hangs up" - we got an empty black console and no ssh response. We think that this is caused by postmaster eating too much memory the last top screenshot is: top - 12:07:46 up 1:06, 2 users, load average: 0.99, 0.93, 0.57 Tasks: 52 total, 3 running, 49 sleeping, 0 stopped, 0 zombie Cpu(s): 99.7% us, 0.3% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 1035532k total, 364012k used, 671520k free, 31292k buffers Swap: 2096472k total, 0k used, 2096472k free, 282468k cached this is not there but while machine is steel up i can see postmaster got 1.6 mem and 99.7% cpu.you can see also that the swap is realy big. This is pgsql 7.4.7 suse 9. We had the same problems with rh 7.3 with pgsql 7.3 bug just managed ... The memory on the machine was checked with memchack and is fine. I know that i can limit the memory usage for postmaster but wouldn't it make to crash ? Thanks. Evgeny.