Re: Memory Problem

Поиск
Список
Период
Сортировка
От Nicolas Michel
Тема Re: Memory Problem
Дата
Msg-id 1238769106.11244.20.camel@nm-laptop
обсуждение исходный текст
Ответ на Re: Memory Problem  (Thomas Markus <t.markus@proventis.net>)
Ответы Re: Memory Problem  (Flavio Henrique Araque Gurgel <flavio@4linux.com.br>)
Список pgsql-admin
Thank you very much. I didn't know that. I set my shmmax to 4000000000 but you're right, we will see to use a 64 bits system ;)


Le vendredi 03 avril 2009 à 12:37 +0200, Thomas Markus a écrit :
hi,

i assume you have a 32bit system so you cant set shmmax to 4gb. as a 
side effect your value 4294967296 in a binary 32bit representation is 
exactly 0. look for previous threads about shmmax. and use a 64bit system :)

regards
thomas

Nicolas Michel schrieb:
> Hi here,
>
> Our server had 2GB of RAM. We added some memory to have 16GB. We are 
> on a debian etch. I installed the "bigmem" kernel to use the all memory :
>
>     ~# cat /proc/meminfo
>     MemTotal:     16573232 kB
>     MemFree:      15448836 kB
>     Buffers:        133772 kB
>     Cached:         445388 kB
>     SwapCached:          0 kB
>     Active:         782764 kB
>     Inactive:       302760 kB
>     HighTotal:    15794120 kB
>     HighFree:     14838384 kB
>     LowTotal:       779112 kB
>     LowFree:        610452 kB
>     SwapTotal:     2658716 kB
>     SwapFree:      2658716 kB
>     Dirty:             452 kB
>     Writeback:           4 kB
>     AnonPages:      506336 kB
>     Mapped:         126524 kB
>     Slab:            27620 kB
>     PageTables:       3036 kB
>     NFS_Unstable:        0 kB
>     Bounce:              0 kB
>     CommitLimit:  10945332 kB
>     Committed_AS:  2187952 kB
>     VmallocTotal:   118776 kB
>     VmallocUsed:      3716 kB
>     VmallocChunk:   114640 kB
>
>
> I wanted to give to postgres 4GB. So I tryied to set shmmax to 4Go :
>
>     sysctl kernel.shmmax=4294967296
>
>
> But it doesn't work : if I launch after this modification this command :
>
>     sysctl kernel.shmmax
>
> it gives me this response :
>
>     kernel.shmmax = 0
>
> Why? Is there a limit to shmmax? 


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

Предыдущее
От: Michael Monnerie
Дата:
Сообщение: Re: Memory Problem
Следующее
От: Carol Walter
Дата:
Сообщение: Full text searching