X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7BE7953A22 for ; Fri, 15 Apr 2005 10:05:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01800-03 for ; Fri, 15 Apr 2005 13:05:02 +0000 (GMT) Received: from mail.eulerhermes.pl (mail.hermes-kredit.pl [217.153.119.83]) by svr1.postgresql.org (Postfix) with ESMTP id 93D1E5334A for ; Fri, 15 Apr 2005 10:04:59 -0300 (ADT) Received: from [192.168.69.4] (helo=[127.0.0.1] ident=nobody) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1DMQVG-0004PU-NB for pgsql-admin@postgresql.org; Fri, 15 Apr 2005 15:05:03 +0200 Message-ID: <425FB913.4020901@eulerhermes.pl> Date: Fri, 15 Apr 2005 14:52:35 +0200 From: Marcin Giedz User-Agent: Mozilla/5.0 (X11; U; Linux i686; pl-PL; rv:1.7.3) Gecko/20040913 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: pgsql-admin Subject: Out of memory problem. Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.089 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/202 X-Sequence-Number: 17215 Hello... Postgres 8.0.1 is running on Debian with 2.6.10 kernel with 12GB of RAM, where 2GB is for shared memory: echo 2147483648 > /proc/sys/kernel/shmall echo 2147483648 > /proc/sys/kernel/shmmax Also overcommit_memory is changed to not "overcommit": pgsql1:/mnt/var# cat /proc/sys/vm/overcommit_memory 2 pgsql1:/mnt/var# but still "out of memory" occures. "shared_buffers" parameter is set to 100000 (according to someone settings can be from 15% to 30% of total RAM memory) - as you can see I have even below 15% of RAM. Earlier "shared_buufers" was set to 50000 and I havn't had this problem. Why I still have "out of memory" despite of changing not overcommit_memory? Thx, Marcin Here is a problem's log Apr 15 14:17:35 pgsql1 kernel: oom-killer: gfp_mask=0x4d0 Apr 15 14:17:35 pgsql1 kernel: DMA per-cpu: Apr 15 14:17:35 pgsql1 kernel: cpu 0 hot: low 2, high 6, batch 1 Apr 15 14:17:35 pgsql1 kernel: cpu 0 cold: low 0, high 2, batch 1 Apr 15 14:17:35 pgsql1 kernel: cpu 1 hot: low 2, high 6, batch 1 Apr 15 14:17:35 pgsql1 kernel: cpu 1 cold: low 0, high 2, batch 1 Apr 15 14:17:35 pgsql1 kernel: cpu 2 hot: low 2, high 6, batch 1 Apr 15 14:17:35 pgsql1 kernel: cpu 2 cold: low 0, high 2, batch 1 Apr 15 14:17:35 pgsql1 kernel: cpu 3 hot: low 2, high 6, batch 1 Apr 15 14:17:35 pgsql1 kernel: cpu 3 cold: low 0, high 2, batch 1 Apr 15 14:17:35 pgsql1 kernel: Normal per-cpu: Apr 15 14:17:35 pgsql1 kernel: cpu 0 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 0 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 1 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 1 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 2 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 2 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 3 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 3 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: HighMem per-cpu: Apr 15 14:17:36 pgsql1 kernel: cpu 0 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 0 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 1 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 1 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 2 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 2 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 3 hot: low 32, high 96, batch 16 Apr 15 14:17:36 pgsql1 kernel: cpu 3 cold: low 0, high 32, batch 16 Apr 15 14:17:36 pgsql1 kernel: Apr 15 14:17:36 pgsql1 kernel: Free pages: 4564kB (768kB HighMem) Apr 15 14:17:36 pgsql1 kernel: Active:2430748 inactive:487388 dirty:114 writeback:0 unstable:0 free:1141 slab:35390 mapped:636143 pagetables:160905 Apr 15 14:17:36 pgsql1 kernel: DMA free:68kB min:68kB low:84kB high:100kB active:24kB inactive:0kB present:16384kB pages_scanned:323 all_unreclaimable? yes Apr 15 14:17:36 pgsql1 kernel: protections[]: 0 0 0 Apr 15 14:17:36 pgsql1 kernel: Normal free:3728kB min:3756kB low:4692kB high:5632kB active:496kB inactive:13072kB present:901120kB pages_scanned:19471 all_unreclaimable? yes Apr 15 14:17:36 pgsql1 kernel: protections[]: 0 0 0 Apr 15 14:17:36 pgsql1 kernel: HighMem free:840kB min:512kB low:640kB high:768kB active:9722344kB inactive:1936480kB present:12189696kB pages_scanned:0 all_unreclaimable? no Apr 15 14:17:36 pgsql1 kernel: protections[]: 0 0 0 Apr 15 14:17:36 pgsql1 kernel: DMA: 1*4kB 0*8kB 0*16kB 0*32kB 1*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 68kB Apr 15 14:17:36 pgsql1 kernel: Normal: 0*4kB 0*8kB 1*16kB 0*32kB 2*64kB 0*128kB 4*256kB 1*512kB 0*1024kB 1*2048kB 0*4096kB = 3728kB Apr 15 14:17:36 pgsql1 kernel: HighMem: 30*4kB 1*8kB 12*16kB 0*32kB 0*64kB 0*128kB 0*256kB 1*512kB 0*1024kB 0*2048kB 0*4096kB = 832kB Apr 15 14:17:36 pgsql1 kernel: Swap cache: add 5948181, delete 5879764, find 2114291/2758769, race 1+19 Apr 15 14:17:36 pgsql1 kernel: Out of Memory: Killed process 20553 (postmaster). Apr 15 14:46:20 pgsql1 -- MARK -- pgsql1:/mnt/var#