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 AE68AD1B19C for ; Fri, 18 Jun 2004 15:48:54 -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 33025-07 for ; Fri, 18 Jun 2004 18:48:51 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id B446AD1B18F for ; Fri, 18 Jun 2004 15:48:49 -0300 (ADT) Received: from [192.168.1.80] (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i5IImdo16120; Fri, 18 Jun 2004 11:48:39 -0700 Message-ID: <40D338BC.7080705@commandprompt.com> Date: Fri, 18 Jun 2004 11:47:24 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 0.6 (X11/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Scott Marlowe Cc: Tom Lane , Domenico Sgarbossa , pgsql-performance@postgresql.org Subject: Re: [BULK] Problems with vacuum! 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> <20554.1087571463@sss.pgh.pa.us> <1087582040.28062.13.camel@localhost.localdomain> In-Reply-To: <1087582040.28062.13.camel@localhost.localdomain> Content-Type: multipart/mixed; boundary="------------000004040304000206060909" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=RAZOR2_CF_RANGE_11_50, RAZOR2_CHECK X-Spam-Level: * X-Archive-Number: 200406/203 X-Sequence-Number: 7261 This is a multi-part message in MIME format. --------------000004040304000206060909 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Hello, I would have to double check BUT I believe this is fixed in later 2.4.x kernels as well. If you don't want to go through the hassle of 2.6 (although it really is a nice kernel) then upgrade to 2.4.26. Sincerely, Joshau D. Drake Scott Marlowe wrote: > On Fri, 2004-06-18 at 09:11, Tom Lane wrote: > >>"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 ... > > > This was a common problem in the linux 2.4 series kernels, but has > supposedly been fixed in the 2.6 kernels. Having lots of memory and > turning off swap will "fix" the problem in 2.4, but if you run out of > real mem, you're hosed. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL --------------000004040304000206060909 Content-Type: text/x-vcard; charset=utf8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0034 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard --------------000004040304000206060909--