Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xw3I8-000869-Ci for pgsql-admin@arkaria.postgresql.org; Wed, 03 Dec 2014 06:20:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xw3I7-0004CF-Ei for pgsql-admin@arkaria.postgresql.org; Wed, 03 Dec 2014 06:19:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xw3I6-0004BN-PV for pgsql-admin@postgresql.org; Wed, 03 Dec 2014 06:19:58 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xw3I3-000844-7Q for pgsql-admin@postgresql.org; Wed, 03 Dec 2014 06:19:57 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mwork.nabble.com (Postfix) with ESMTP id D7DE0C67DBD for ; Tue, 2 Dec 2014 22:19:54 -0800 (PST) Date: Tue, 2 Dec 2014 23:19:54 -0700 (MST) From: David G Johnston To: pgsql-admin@postgresql.org Message-ID: <1417587594344-5829039.post@n5.nabble.com> In-Reply-To: <2a1c11c6.8b89.14a0eae5ff0.Coremail.goonsinging@163.com> References: <2a1c11c6.8b89.14a0eae5ff0.Coremail.goonsinging@163.com> Subject: Re: pgpool use up memory MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.3 (/) 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 Kevin Burns wrote > Dear all, > > I use pgpool-3.3.4 to do the loading balance and failover with two pg > server backend. > > the pgpool server use up all 32G memory and crash(2 pg server are fine). > > Any ideas why pg-pool use so much memory ? > > how to reduce the memory usage of pg-pool. > > Thanks in advance. > > Kevin Zhang > Shanghai This lacks sufficient detail and is addressed to an improper forum as it seems to be a pg-pool usage problem which is not a project that the core PostgreSQL team maintains. You should try raising a more detailed question on whatever support mediums they provide. At minimum you should show your config and some logging/status output around the time the crash happens. David J. -- View this message in context: http://postgresql.nabble.com/pgpool-use-up-memory-tp5829033p5829039.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin