Re: out of memory errors - Mailing list pgsql-general

From Bruce McAlister
Subject Re: out of memory errors
Date
Msg-id 539EEF64.1040006@blueface.com
Whole thread Raw
In response to Re: out of memory errors  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: out of memory errors
List pgsql-general
Hi,

On 16/06/2014 14:15, Andres Freund wrote:
> Hi,
>
> On 2014-06-16 13:56:23 +0100, Bruce McAlister wrote:
>>      [1] 3 x ESX VM's
>>                  [a] 8 vCPU's each
>>                  [b] 16GB memory each
>> # Dont hand out more memory than neccesary
>> vm.overcommit_memory = 2
> So you haven't tune overcommit_ratio at all? Can you show
> /proc/meminfo's contents?
> My guess is that the CommitLimit is too low...
>

No I have not tune overcommit_ratio.

Below is the /proc/meminfo contents. One note though, the database is
currently not running on this node, just in case i need to make some
changes that require a restart.

[root@bfievdb01 heartbeat]# cat /proc/meminfo
MemTotal:       16333652 kB
MemFree:         2928544 kB
Buffers:          197216 kB
Cached:          1884032 kB
SwapCached:            0 kB
Active:          4638780 kB
Inactive:        1403676 kB
Active(anon):    4006088 kB
Inactive(anon):     7120 kB
Active(file):     632692 kB
Inactive(file):  1396556 kB
Unevictable:       65004 kB
Mlocked:           56828 kB
SwapTotal:      22015984 kB
SwapFree:       22015984 kB
Dirty:              3616 kB
Writeback:             0 kB
AnonPages:       4026228 kB
Mapped:            82408 kB
Shmem:             45352 kB
Slab:             197052 kB
SReclaimable:     106804 kB
SUnreclaim:        90248 kB
KernelStack:        4000 kB
PageTables:        15172 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:    30182808 kB
Committed_AS:    4342644 kB
VmallocTotal:   34359738367 kB
VmallocUsed:     7004496 kB
VmallocChunk:   34352726816 kB
HardwareCorrupted:     0 kB
AnonHugePages:   3868672 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:       10240 kB
DirectMap2M:    16766976 kB

Thanks
Bruce


pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: out of memory errors
Next
From: Ravi Kiran
Date:
Subject: eclipse-gdb