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 6A5B5536E0 for ; Tue, 12 Apr 2005 11:09:07 -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 01785-09 for ; Tue, 12 Apr 2005 14:09:03 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C608E53594 for ; Tue, 12 Apr 2005 11:08:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3CE91Z7015395; Tue, 12 Apr 2005 10:09:02 -0400 (EDT) To: Tsirkin Evgeny Cc: pgsql-admin@postgresql.org Subject: Re: db restore eats too much memory In-reply-to: <425B98BF.5090400@mail.jct.ac.il> References: <425B98BF.5090400@mail.jct.ac.il> Comments: In-reply-to Tsirkin Evgeny message dated "Tue, 12 Apr 2005 12:45:35 +0300" Date: Tue, 12 Apr 2005 10:09:01 -0400 Message-ID: <15394.1113314941@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/155 X-Sequence-Number: 17168 Tsirkin Evgeny writes: > 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. No, I can see that the swap isn't being touched at all ... and main memory seems to have a lot of slop too. Whatever problem you may be having here, it doesn't seem to be out-of-memory. regards, tom lane