From: | Nicolas Michel <nicolas(dot)michel(at)lemail(dot)be> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Memory Problem |
Date: | 2009-04-03 14:31:46 |
Message-ID: | 1238769106.11244.20.camel@nm-laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Carol Walter | 2009-04-03 18:32:02 | Full text searching |
Previous Message | Thomas Markus | 2009-04-03 10:37:40 | Re: Memory Problem |