Search Postgresql Archives

Re: Out of memory on SELECT in 8.3.5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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@170226-db7 ~]# cat /proc/sys/vm/overcommit_memory
2

[root@170226-db7 ~]# cat /proc/sys/vm/overcommit_ratio
50

[root@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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux