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 3DE4F3A4030 for ; Tue, 18 Jan 2005 02:32:38 +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 04139-08 for ; Tue, 18 Jan 2005 02:32:30 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 418E13A401F for ; Tue, 18 Jan 2005 02:32:32 +0000 (GMT) Received: (qmail 6128 invoked from network); 18 Jan 2005 02:35:15 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 18 Jan 2005 02:35:15 -0000 Received: from webmail.moph.go.th ([127.0.0.1]) by localhost (webmail.moph.go.th [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 04245-31 for ; Tue, 18 Jan 2005 09:35:13 +0700 (ICT) Received: (qmail 6113 invoked from network); 18 Jan 2005 02:35:13 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 18 Jan 2005 02:35:13 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Tue, 18 Jan 2005 09:35:12 +0700 Message-ID: <1106015712.41ec75e0e1e7f@webmail.moph.go.th> Date: Tue, 18 Jan 2005 09:35:12 +0700 From: amrit@health2.moph.go.th To: Mark Kirkwood Cc: PGsql-performance Subject: Re: Increasing RAM for more than 4 Gb. using postgresql References: <1105501768.41e49e484d779@webmail.moph.go.th> <1105837366.41e9bd36c7de9@webmail.moph.go.th> <1106003849.41ec4789089f1@webmail.moph.go.th> <41EC556F.6030604@coretech.co.nz> In-Reply-To: <41EC556F.6030604@coretech.co.nz> MIME-Version: 1.0 Content-Type: text/plain; charset=TIS-620 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 203.157.100.42 X-Virus-Scanned: by amavisd-new at moph.go.th X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/218 X-Sequence-Number: 9908 > I understand that the 2.6.* kernels are much better at large memory > support (with respect to performance issues), so unless you have a > 64-bit machine lying around - this is probably worth a try. > > You may need to build a new kernel with the various parameters : > > CONFIG_NOHIGHMEM > CONFIG_HIGHMEM4G > CONFIG_HIGHMEM64G > > set appropriately (or even upgrade to the latest 2.6.10). I would expect > that some research and experimentation will be required to get the best > out of it - (e.g. the 'bounce buffers' issue). In the standard rpm FC 2-3 with a newly install server , would it automatically detect and config it if I use the mechine with > 4 Gb [6Gb.] or should I manually config it? Amrit Thailand