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 3732CD1B188 for ; Fri, 18 Jun 2004 12:11:10 -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 93573-06 for ; Fri, 18 Jun 2004 15:11:05 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E033AD1B170 for ; Fri, 18 Jun 2004 12:11:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5IFB4MP020555; Fri, 18 Jun 2004 11:11:04 -0400 (EDT) To: "Domenico Sgarbossa" Cc: pgsql-performance@postgresql.org Subject: Re: [BULK] Problems with vacuum! In-reply-to: <011101c4553b$c1967130$70c8007e@xtecnica.it> References: <003c01c44fbd$c84a6af0$2500fa0a@CardServices.TCI.com><004c01c44fc3$d7cdeaf0$70c8007e@xtecnica.it> <87pt8616i3.fsf@asmodeus.mcnaught.org> <1087226647.1775.14.camel@kaos> <011101c4553b$c1967130$70c8007e@xtecnica.it> Comments: In-reply-to "Domenico Sgarbossa" message dated "Fri, 18 Jun 2004 15:54:20 +0200" Date: Fri, 18 Jun 2004 11:11:03 -0400 Message-ID: <20554.1087571463@sss.pgh.pa.us> From: Tom Lane 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/193 X-Sequence-Number: 7251 "Domenico Sgarbossa" writes: > so when the users go home, i've got something like 15/20000kb free ram, the > rest is cached and 0kb of swap... > It seems that when pg_dump starts the cached memory isn't released so the > system begin to swap, A sane kernel should drop disk buffers rather than swapping. We heard recently about a bug in some versions of the Linux kernel that cause it to prefer swapping to discarding disk cache, though. It sounds like that's what you're hitting. Look into newer kernels ... regards, tom lane