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
|
Список | 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 :
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 по дате отправления: