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

From Josh Berkus
Subject Re: Increasing RAM for more than 4 Gb. using postgresql
Date
Msg-id 200501160944.47511.josh@agliodbs.com
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
List pgsql-performance
William,

> The theshold for using PAE is actually far lower than 4GB. 4GB is the
> total memory address space -- split that in half for 2GB for userspace,
> 2GB for kernel. The OS cache resides in kernel space -- after you take
> alway the memory allocation for devices, you're left with a window of
> roughly 900MB.

I'm curious, how do you get 1.1GB for memory allocation for devices?

--
Josh Berkus
Aglio Database Solutions
San Francisco

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: Kaloyan Iliev Iliev
Date:
Subject: Performance problem from migrating between versions!