Re: Out of memory on SELECT in 8.3.5

Поиск
Список
Период
Сортировка
От Matt Magoffin
Тема Re: Out of memory on SELECT in 8.3.5
Дата
Msg-id 49274.192.168.1.106.1234210016.squirrel@msqr.us
обсуждение исходный текст
Ответ на Re: Out of memory on SELECT in 8.3.5  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Out of memory on SELECT in 8.3.5  (Stephen Frost <sfrost@snowman.net>)
Список 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@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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Matt Magoffin"
Дата:
Сообщение: Re: Out of memory on SELECT in 8.3.5
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Out of memory on SELECT in 8.3.5