Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 39BE79FB2D9 for ; Fri, 13 Apr 2007 17:25:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02065-05 for ; Fri, 13 Apr 2007 17:24:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C32ED9FB2F2 for ; Fri, 13 Apr 2007 17:25:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtpauth00.csee.siteprotect.com (smtpauth00.csee.siteprotect.com [64.41.126.131]) by svr4.postgresql.org (Postfix) with ESMTP id 1C3405AF8A6 for ; Fri, 13 Apr 2007 20:25:00 +0000 (GMT) Received: from waterloo (wsp05975341wss.cr.net.cable.rogers.com [24.235.117.179]) by smtpauth00.csee.siteprotect.com (Postfix) with ESMTP id EB18832C055 for ; Fri, 13 Apr 2007 15:24:56 -0500 (CDT) Received: by waterloo (sSMTP sendmail emulation); Fri, 13 Apr 2007 16:24:55 -0400 From: "Jan de Visser" To: pgsql-performance@postgresql.org Subject: Re: Question about memory allocations Date: Fri, 13 Apr 2007 16:24:55 -0400 User-Agent: KMail/1.9.6 References: <233A9987-ABA5-4491-A304-FDA1F8FCD962@gmail.com> <461FD1C1.8040502@mochima.com> In-Reply-To: <461FD1C1.8040502@mochima.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200704131624.55903.jdevisser@digitalfairway.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.299 tagged_above=0 required=5 tests=AWL=0.298, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200704/298 X-Sequence-Number: 24175 On Friday 13 April 2007 14:53:53 Carlos Moreno wrote: > How does PG take advantage of the available memory? =A0I mean, if I have a > machine with, say, 4 or 8GB of memory, how will those GBs would end > up being used? =A0 They just do?? =A0 (I mean, I would find that a vaild > answer; On linux the filesystem cache will gobble them up, which means indirectly=20 pgsql profits as well (assuming no other apps poison the fs cache). jan =2D-=20 =2D------------------------------------------------------------- Jan de Visser =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 jdevisser@digitalfair= way.com =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Baruk Khazad! Khazad ai-menu! =2D-------------------------------------------------------------