Re: Increasing RAM for more than 4 Gb. using postgresql - Mailing list pgsql-performance

From Dave Cramer
Subject Re: Increasing RAM for more than 4 Gb. using postgresql
Date
Msg-id 41EC4C03.9020407@fastcrypt.com
Whole thread Raw
In response to Re: Increasing RAM for more than 4 Gb. using postgresql  (amrit@health2.moph.go.th)
Responses Re: Increasing RAM for more than 4 Gb. using postgresql
List pgsql-performance
Amrit,

It's not useless, it's just not optimal.

All operating systems, FC2, FC3, .... will have the same problem with
greater than 4G of memory on a 32 bit processor.

The *only* way to avoid this is to go to a 64 bit processor (opteron) and then
for greater performance use a linux distribution compiled for a 64bit processor.

Have you identified and optimized the queries, are you sure you need more memory?

Dave

amrit@health2.moph.go.th wrote:
Since the optimal state is to allocate a small amount of memory to
Postgres and leave a huge chunk to the OS cache, this means you are
already hitting the PAE penalty at 1.5GB of memory.
       
How could I change this hitting?     
Upgrade to 64-bit processors + 64-bit linux.   
Does the PAE help linux in handling the memory of more than 4 Gb limit in 32 bit
archetech ? My intel server board could handle the mem of 12 Gb [according to
intel spec.] and if I use Fedora C2 with PAE , will it useless for mem of more
than >4Gb.?

Any comment please?
Amrit
Thailand


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command   (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

 

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561

pgsql-performance by date:

Previous
From: amrit@health2.moph.go.th
Date:
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql
Next
From: Mark Kirkwood
Date:
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql