Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bxp5R-0006aB-LU for pgsql-admin@arkaria.postgresql.org; Sat, 22 Oct 2016 05:43:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bxp5P-0007H9-Nz for pgsql-admin@arkaria.postgresql.org; Sat, 22 Oct 2016 05:43:15 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bxp5N-0007Gm-9E for pgsql-admin@postgresql.org; Sat, 22 Oct 2016 05:43:13 +0000 Received: from m12-16.163.com ([220.181.12.16]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bxp5H-0008Em-F9 for pgsql-admin@postgresql.org; Sat, 22 Oct 2016 05:43:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=Date:From:Subject:Mime-Version:Message-ID; bh=YLa5Q hbWwJCWGCqkiPN855gDjqbg+3l79WkiNds3PuA=; b=ZUjQZFvqGrykJYZkRopUB N6N6dz9xzvq3LiTGtqWY/UpzJ7mbu1sP45My33jRiHfaQAxCFqSjMfEM9T3mCVDm AJ//zdTkKlTGJTF6LD3T+wz/cuqbNKLnSipMVQzq5F8kfwhjxKmCVRS1d4LmQQ0v t8BI4h4yzq9+6/ZmoaVl7U= Received: from db (unknown [101.40.71.117]) by smtp12 (Coremail) with SMTP id EMCowAD3_dJk_ApYaVCEBA--.29314S2; Sat, 22 Oct 2016 13:43:01 +0800 (CST) Date: Sat, 22 Oct 2016 13:43:01 +0800 From: "dbyzaa@163.com" To: pgsql-admin Subject: WARNING: out of shared memory X-Priority: 3 X-GUID: 5205F73E-FB9C-418F-8732-5B5196C7AD0A X-Has-Attach: no X-Mailer: Foxmail 7, 2, 7, 174[cn] Mime-Version: 1.0 Message-ID: <2016102213430009423014@163.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart288481348025_=----" X-CM-TRANSID: EMCowAD3_dJk_ApYaVCEBA--.29314S2 X-Coremail-Antispam: 1Uf129KBjvJXoW7AF1xuFyruw4DKw1rGFWrGrg_yoW8Jw13pw 4Iqr15CrWkArWkJrn3uayfCas7tws5Zay5J3sxA348K34UCrWvqrWvqa4agw1UAw4Yga98 Z345Zw1qy3ZFvaUanT9S1TB71UUUUUUqnTZGkaVYY2UrUUUUjbIjqfuFe4nvWSU5nxnvy2 9KBjDUYxBIdaVFxhVjvjDU0xZFpf9x07UkpndUUUUU= X-Originating-IP: [101.40.71.117] X-CM-SenderInfo: xge16trd6rljoofrz/1tbiQAULOFSIQ0sqVAAAsc X-Pg-Spam-Score: -0.6 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. ------=_001_NextPart288481348025_=---- Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: base64 aGVsbG8NCiAgICB3aGVuIGkgdHJ5IHRvIHJ1biBhIGZ1bmN0aW9uLCBpIGZvdW5kIHNvbWUgbWVz c2FnZSBpbiBwZ19sb2cNCldBUk5JTkc6ICBvdXQgb2Ygc2hhcmVkIG1lbW9yeQ0KQ09OVEVYVDog IFBML3BnU1FMIGZ1bmN0aW9uIGFyaXRoLnRlc3QoY2hhcmFjdGVyLGNoYXJhY3RlcixjaGFyYWN0 ZXIsaW50ZWdlcixjaGFyYWN0ZXIpIGxpbmUgODkgYXQgRkVUQ0gNClNRTCBzdGF0ZW1lbnQgInNl bGVjdCBhLnBfdHJhaW5fbm8gICAgICAgICAgICAgICAgICAgZnJvbSBhcml0aC5DSjMwX3RyYWlu X2NvZGUoDQp2X25zX3RyYWluX2RhdGUsdl9jX3RyYWluX25vICx2X3NpbmdsZV9hc3NpZ25fc3Rh dGlvbiwwLCcnKSBhcyBhIg0KUEwvcGdTUUwgZnVuY3Rpb24gYXJpdGgudGVzdChpbnRlZ2VyLGNo YXJhY3RlciB2YXJ5aW5nLGNoYXJhY3RlciB2YXJ5aW5nLGludGVnZXIsY2hhcmFjdGVyLGNoYXJh Y3RlcikgbGluZSAxMDQzIGF0IFNRTCBzdGF0ZW1lbnQNCldBUk5JTkc6ICBvdXQgb2Ygc2hhcmVk IG1lbW9yeQ0KQ09OVEVYVDogIFBML3BnU1FMIGZ1bmN0aW9uIGFyaXRoLnRlc3QyKGNoYXJhY3Rl cixjaGFyYWN0ZXIsY2hhcmFjdGVyLGludGVnZXIsY2hhcmFjdGVyKSBsaW5lIDg5IGF0IEZFVENI DQoNCmVudmlyb25tZW50Og0KcmVkaGFsdCA2LjINClBvc3RncmVTUUwgOS42LjAgDQptZW06MjRH Qg0KDQpzeXNjdGwuY29uZg0Ka2VybmVsLnNobW1heCA9IDEyODg0OTAxODg4DQprZXJuZWwuc2ht YWxsID0gNDcxODU5Mg0Kdm0uc3dhcHBpbmVzcyA9IDANCnZtLm92ZXJjb21taXRfbWVtb3J5ID0g Mg0Kdm0ub3ZlcmNvbW1pdF9yYXRpbyA9IDgwDQp2bS5kaXJ0eV9yYXRpbyA9IDEwDQp2bS5kaXJ0 eV9iYWNrZ3JvdW5kX3JhdGlvID0gMQ0Kdm0udmZzX2NhY2hlX3ByZXNzdXJlPTE1MA0Kdm0uZGly dHlfd3JpdGViYWNrX2NlbnRpc2VjcyA9IDUwDQpuZXQuaXB2NC50Y3BfdHdfcmVjeWNsZT0xDQpu ZXQuaXB2NC50Y3BfdHdfcmV1c2U9MQ0Kdm0ubnJfaHVnZXBhZ2VzPTIzMDANCg0KcG9zdGdyZXNx bC5jb25mDQpzaGFyZWRfYnVmZmVycyA9IDRHQiAjIG1pbiAxMjhrQg0KaHVnZV9wYWdlcyA9IG9u ICMgb24sIG9mZiwgb3IgdHJ5DQp3b3JrX21lbSA9IDY0TUIgIyBtaW4gNjRrQg0KbWFpbnRlbmFu Y2Vfd29ya19tZW0gPSA1MTJNQiAjIG1pbiAxTUINCm1heF9zdGFja19kZXB0aCA9IDhNQiAjIG1p biAxMDBrQg0KZHluYW1pY19zaGFyZWRfbWVtb3J5X3R5cGUgPSBwb3NpeCAjIHRoZSBkZWZhdWx0 IGlzIHRoZSBmaXJzdCBvcHRpb24NCg0KDQpkYnl6YWFAMTYzLmNvbQ0K ------=_001_NextPart288481348025_=---- Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =0A
hello
    when i try to run a function, i f= ound some message in pg_log
WARNING: &= nbsp;out of shared memory
CONTEXT:  PL/pgSQL&n= bsp;function arith.test(character,character,character,integer,charact= er) line 89 at FETCH
SQL statement "select a.p_train_no  &= nbsp;           &nb= sp;    from arith.CJ30_train_code(
<= span style=3D"white-space: pre;"> <= span style=3D"white-space: pre;"> v_ns_train_date,v_c_train_no ,v_single_assign_station,0,'')&= nbsp;as a"
PL/pgSQL = ;function arith.test(integer,character varying,character va= rying,integer,character,character) line 1043 at SQL&nb= sp;statement
WARNING:  out of shared memoryCONTEXT:  PL/pgSQL function arith.test2(character,cha= racter,character,integer,character) line 89 at FETCH

environment:
redhalt 6.2
PostgreSQL 9.6.0 
mem:24GB

sysctl.conf
kernel.shmmax =3D 12884901888
k= ernel.shmall =3D 4718592
vm.swappiness =3D 0
vm.= overcommit_memory =3D 2
vm.overcommit_ratio =3D 80<= br>vm.dirty_ratio =3D 10
vm.dirty_background_ratio =3D&n= bsp;1
vm.vfs_cache_pressure=3D150
vm.dirty_writeback_centisecs = =3D 50
net.ipv4.tcp_tw_recycle=3D1
net.ipv4.tcp_tw_reuse=3D1vm.nr_hugepages=3D2300

= postgresql.conf
= shared_buffers =3D 4GB = # min 128kB
= huge_pages =3D on # on, off, or try
work_mem =3D 64MB<= span style=3D"white-space: pre;"> # min 64kB
maintenance_work_mem =3D&n= bsp;512MB # min 1MB
max_stack_depth =3D 8M= B # min 100kB=
dynamic_shared_memory_type =3D posix # the default is the first = ;option
=0A
dbyz= aa@163.com
=0A ------=_001_NextPart288481348025_=------