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

Поиск
Список
Период
Сортировка
От amrit@health2.moph.go.th
Тема Re: Increasing RAM for more than 4 Gb. using postgresql
Дата
Msg-id 1105837366.41e9bd36c7de9@webmail.moph.go.th
обсуждение исходный текст
Ответ на Re: Increasing RAM for more than 4 Gb. using postgresql  (William Yu <wyu@talisys.com>)
Ответы Re: Increasing RAM for more than 4 Gb. using postgresql
Список pgsql-performance
> 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 set shammax =
[root@data3 /]# cat < /proc/sys/kernel/shmmax
4000000000
shmall =
[root@data3 /]# cat < /proc/sys/kernel/shmall
134217728
Is that ok for 4 Gb. mechine?

> 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?
Thanks
Amrit
Thailand

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: IN() Optimization issue in 8.0rc5
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Increasing RAM for more than 4 Gb. using postgresql