From: | "Matt Magoffin" <postgresql(dot)org(at)msqr(dot)us> |
---|---|
To: | "Stephen Frost" <sfrost(at)snowman(dot)net> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Out of memory on SELECT in 8.3.5 |
Date: | 2009-02-09 20:06:56 |
Message-ID: | 49274.192.168.1.106.1234210016.squirrel@msqr.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Err, yea, overcommit_memory=2, a small amount of swap space, and a low
> overcommit_ratio could cause this to happen... The default
> ratio is 50 though, which should mean, on this system, there is about
> 10G available for user processes, but his usage shows only a bit over 2G
> being used outside of buffers/caches (based on free output)..
>
> Matt, can you provide the output from these:
> cat /proc/sys/vm/overcommit_memory
>
> cat /proc/sys/vm/overcommit_ratio
>
> cat /proc/meminfo
Sure, here you go:
[root(at)170226-db7 ~]# cat /proc/sys/vm/overcommit_memory
2
[root(at)170226-db7 ~]# cat /proc/sys/vm/overcommit_ratio
50
[root(at)170226-db7 ~]# cat /proc/meminfo
MemTotal: 16432296 kB
MemFree: 160188 kB
Buffers: 164764 kB
Cached: 14006456 kB
SwapCached: 0 kB
Active: 6984144 kB
Inactive: 8471456 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 16432296 kB
LowFree: 160188 kB
SwapTotal: 2096440 kB
SwapFree: 2095992 kB
Dirty: 540 kB
Writeback: 0 kB
AnonPages: 1270076 kB
Mapped: 4258192 kB
Slab: 211448 kB
PageTables: 559248 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 10312588 kB
Committed_AS: 9760756 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 263556 kB
VmallocChunk: 34359474475 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
Hugepagesize: 2048 kB
Regards,
Matt
From | Date | Subject | |
---|---|---|---|
Next Message | Patryk Kordylewski | 2009-02-09 20:15:32 | Calling overloaded function with NULL argument |
Previous Message | Matt Magoffin | 2009-02-09 20:04:48 | Re: Out of memory on SELECT in 8.3.5 |