Postgres Pro
Downloads
Home   >   mailing lists

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

From amrit@health2.moph.go.th
Subject Re: Increasing RAM for more than 4 Gb. using postgresql
Date
Msg-id 1106003849.41ec4789089f1@webmail.moph.go.th
Whole thread Raw
In response to Re: Increasing RAM for more than 4 Gb. using postgresql  (William Yu <wyu@talisys.com>)
Responses Re: Increasing RAM for more than 4 Gb. using postgresql  (Dave Cramer <pg@fastcrypt.com>)
Re: Increasing RAM for more than 4 Gb. using postgresql  (Mark Kirkwood <markir@coretech.co.nz>)
List pgsql-performance
Tree view 
> >>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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance problem from migrating between versions!
Next
From: Dave Cramer
Date:
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql