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 3CB4B3A18A8 for ; Tue, 18 Jan 2005 13:05:05 +0000 (GMT) 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 10260-07 for ; Tue, 18 Jan 2005 13:04:57 +0000 (GMT) Received: from pfepb.post.tele.dk (pfepb.post.tele.dk [195.41.46.236]) by svr1.postgresql.org (Postfix) with ESMTP id 84B713A18A7 for ; Tue, 18 Jan 2005 13:04:57 +0000 (GMT) Received: from freedom (0x535b8898.taanxx1.adsl-dhcp.tele.dk [83.91.136.152]) by pfepb.post.tele.dk (Postfix) with SMTP id 44F2A5EE065; Tue, 18 Jan 2005 14:04:51 +0100 (CET) Message-ID: <011901c4fd5e$4b465470$63070080@freedom> From: "Nicolai Petri (lists)" To: "William Yu" , References: <1105501768.41e49e484d779@webmail.moph.go.th> <200501160944.47511.josh@agliodbs.com> Subject: Re: Increasing RAM for more than 4 Gb. using postgresql Date: Tue, 18 Jan 2005 14:04:45 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/223 X-Sequence-Number: 9913 This must be a linux'ism because to my knowledge FreeBSD does not keep the os-cache mapped into the kernel address space unless it have active objects associated with the data. And FreeBSD also have a default split of 3GB userspace and 1GB. kernelspace when running with a default configuration. Linux people might want to try other os'es to compare the performance. Best regards, Nicolai Petri Ps. Sorry for my lame MS mailer - quoting is not something it knows how to do. :) ----- Original Message ----- From: "William Yu" >I inferred this from reading up on the compressed vm project. It can be >higher or lower depending on what devices you have in your system -- > however, I've read messages from kernel hackers saying Linux is very > aggressive in reserving memory space for devices because it must be > allocated at boottime. > > > > Josh Berkus wrote: >> William, >> >> >>>The theshold for using PAE is actually far lower than 4GB. 4GB is the >>>total memory address space -- split that in half for 2GB for userspace, >>>2GB for kernel. The OS cache resides in kernel space -- after you take >>>alway the memory allocation for devices, you're left with a window of >>>roughly 900MB. >> >> >> I'm curious, how do you get 1.1GB for memory allocation for devices? >>