X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1EC7ED1B1CB for ; Fri, 11 Jun 2004 12:03:56 -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 61164-08 for ; Fri, 11 Jun 2004 15:03:54 +0000 (GMT) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id A959ED1B1A1 for ; Fri, 11 Jun 2004 12:03:53 -0300 (ADT) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1BYnZP-0000mO-00 for ; Fri, 11 Jun 2004 17:03:51 +0200 Received: from sp-260-1.net4.netcentrix.net ([4.21.254.118]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 11 Jun 2004 17:03:51 +0200 Received: from doug by sp-260-1.net4.netcentrix.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 11 Jun 2004 17:03:51 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Doug McNaught Subject: Re: [BULK] Problems with vacuum! Date: Fri, 11 Jun 2004 11:03:48 -0400 Lines: 14 Message-ID: <87pt8616i3.fsf@asmodeus.mcnaught.org> References: <003c01c44fbd$c84a6af0$2500fa0a@CardServices.TCI.com> <004c01c44fc3$d7cdeaf0$70c8007e@xtecnica.it> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: sp-260-1.net4.netcentrix.net User-Agent: Gnus/5.1002 (Gnus v5.10.2) Emacs/20.7 (gnu/linux) Cancel-Lock: sha1:y4KkfkG8JUBSW+SnmQbUzOZ/omQ= X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/128 X-Sequence-Number: 7186 "Domenico Sgarbossa" writes: > Thanks for your advice! > > It seems that the cached memory isn't released by the system... so the > system begin to swap to disk! If you really think this is true, there should be a process that is holding on to the memory. Use 'ps' to find that process. I also noticed that your shared_buffers setting seemed a bit low--you might want to increase it. -Doug