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 3CE8A3A5CF8 for ; Wed, 12 Jan 2005 15:19:13 +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 29195-06 for ; Wed, 12 Jan 2005 15:19:05 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196]) by svr1.postgresql.org (Postfix) with ESMTP id 2F8B33A5CEE for ; Wed, 12 Jan 2005 15:19:06 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 67so344917wri for ; Wed, 12 Jan 2005 07:19:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=CM1UAOcRtunoRM7Z/wK8RvackV/80SIn7BC3hcWHnRNKUSWO6bqHHeR4AxMGQy9pKHO/NwoDidCtAxXFCRjA6Nf7UW9Nr6U4kB5QzLt6R0UBaMqD7/vpw9q785Jnomf58D45c57Q8g1NZOStEHCzmirfLxXYSWsjd7TQ7jq+JmI= Received: by 10.54.3.2 with SMTP id 2mr127237wrc; Wed, 12 Jan 2005 07:19:06 -0800 (PST) Received: by 10.54.4.50 with HTTP; Wed, 12 Jan 2005 07:19:06 -0800 (PST) Message-ID: <1eae200b05011207191f2efd01@mail.gmail.com> Date: Wed, 12 Jan 2005 16:19:06 +0100 From: Martin Tedjawardhana Reply-To: Martin Tedjawardhana To: "amrit@health2.moph.go.th" Subject: Re: Increasing RAM for more than 4 Gb. using postgresql Cc: Gavin Sherry , PGsql-performance In-Reply-To: <1105541313.41e538c110c38@webmail.moph.go.th> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <1105501768.41e49e484d779@webmail.moph.go.th> <1105541313.41e538c110c38@webmail.moph.go.th> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.023 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP, TO_ADDRESS_EQ_REAL X-Spam-Level: * X-Archive-Number: 200501/150 X-Sequence-Number: 9840 > Yes , of course I must try to upgrade PGsql to 7.4 and may be OS to FC 2-3 too. > My server products are intel based [mainboard , CPU ,Case , Power supply ,RAID > Network card] dual Xeon 32 bit 3.0 Ghz which I consulted Thai intel supervisor > and they told me that increasing the ram for more than 4 Gb. may be possible > depending on the OS. I never tried FC before, but I recommend using Debian (with custom kernel) or if you have the patience: Gentoo. Those are "strictly business" distros, no unnecesary stuffs running after installation. Providing a good base for you to focus on performance tweaks. Others may have different opinions, though...