Postgres Pro
Downloads
Home   >   mailing lists

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

From William Yu
Subject Re: Increasing RAM for more than 4 Gb. using postgresql
Date
Msg-id csgtgm$2lae$2@news.hub.org
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
Tree view 
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 chang this hitting?

Upgrade to 64-bit processors + 64-bit linux.

pgsql-performance by date:

Previous
From: William Yu
Date:
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql
Next
From: Kaloyan Iliev Iliev
Date:
Subject: Re: Performance problem from migrating between versions!