Re: Increasing RAM for more than 4 Gb. using postgresql

From: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
To: amrit(at)health2(dot)moph(dot)go(dot)th
Cc: PGsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql
Date: 2005-01-12 12:44:55
Message-ID: Pine.LNX.4.58.0501122343160.6728@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 12 Jan 2005 amrit(at)health2(dot)moph(dot)go(dot)th wrote:

> I wonder if I would like to increase more RAM from 4 Gb. to 6 Gb. [which I hope
> to increase more performance ] and I now I used RH 9 and Pgsql 7.3.2 ON DUAL
> Xeon 3.0 server thay has the limtation of 4 Gb. ram, I should use which OS
> between FC 2-3 or redhat EL 3 [which was claimed to support 64 Gb.ram] .May I
> use FC 2 [which is freely downloaded] with 6 Gb. and PGsql 7.4 ?

There is no problem with free Linux distros handling > 4 GB of memory. The
problem is that 32 hardware must make use of some less than efficient
mechanisms to be able to address the memory.

So, try 7.4 before the memory upgrade. If you still have performance issues,
try optimising your queries. As I mentioned before, you can join the
#postgresql channel on irc.freenode.net and we can assist.

Gavin

> Amrit
> Thailand

Gavin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message amrit 2005-01-12 14:48:33 Re: Increasing RAM for more than 4 Gb. using postgresql
Previous Message Gavin Sherry 2005-01-12 12:40:03 Re: Increasing RAM for more than 4 Gb. using postgresql