X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id A7A1B31030A for ; Fri, 27 Jun 2003 20:55:51 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 36885-04 for ; Fri, 27 Jun 2003 17:55:41 -0300 (ADT) Received: from mailhost3.tudelft.nl (mailhost3.tudelft.nl [130.161.180.83]) by svr1.postgresql.org (Postfix) with ESMTP id 14CA1310398 for ; Fri, 27 Jun 2003 17:55:41 -0300 (ADT) Received: from 127.0.0.1 (localhost [127.0.0.1]) by rav.antivirus (Postfix) with SMTP id DB8B753A; Fri, 27 Jun 2003 22:55:40 +0200 (MEST) Received: from listserv.tudelft.nl (listserv.tudelft.nl [130.161.180.33]) by mailhost3.tudelft.nl (Postfix) with ESMTP id 68097539; Fri, 27 Jun 2003 22:55:40 +0200 (MEST) Received: from acm (x193056-2.shuis-s.tudelft.nl [145.94.193.58]) by listserv.tudelft.nl (8.12.8p1/8.12.8) with ESMTP id h5RKtQDb024581; Fri, 27 Jun 2003 22:55:40 +0200 (MEST) From: "Arjen van der Meijden" To: "'Matthew Hixson'" , Subject: Re: Memory question Date: Fri, 27 Jun 2003 22:55:40 +0200 Message-ID: <004b01c33cee$7e6b2560$3ac15e91@acm> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <30A40B16-A8DE-11D7-81EC-000393669C1A@poindextrose.org> Importance: Normal X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Archive-Number: 200306/198 X-Sequence-Number: 2282 > I've heard that too, but it doesn't seem to make much sense > to me. If > you get to the point where your machine is _needing_ 2GB of swap then > something has gone horribly wrong (or you just need more RAM in the > machine) and it will just crawl until the kernel kills off whatever > process causes the swap space to be exceeded. Seems to me that you > should only have that much swap if you can't afford more RAM > or you've > tapped out your machine's capacity, and your application needs that > much memory. > -M@ I've heard the same, the reason behind it was that there needs to be one-to-one copy of the memory to be able to swap out everything and to have a gain in the total "memory", you'd need twice as much swap as memory to have a doubling of your memory. But afaik this behaviour has been adjusted since the 2.4.5 kernel and isn't a real issue anymore. Please keep in mind that I'm no expert at all on linux, so if you want to be sure, you'd better mail to the kernel-mailinglist orso :) Anyway, I manage a few machines with 1GB++ memory and none of them has more than 1G of swap and none of them uses that swap for more than a few MB unless something was terribly wrong, so the actual 'risk' probably doesn't have a high chance to occur. Arjen