Re: Out of memory on SELECT in 8.3.5

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

In response to

Responses

Browse pgsql-general by date

  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