X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1812630E35D for ; Mon, 16 Jun 2003 20:34:18 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 21166-09 for ; Mon, 16 Jun 2003 17:34:07 -0300 (ADT) Received: from smaug.securitymatrix.com (unknown [64.25.5.177]) by svr1.postgresql.org (Postfix) with ESMTP id 2616830EEFF for ; Mon, 16 Jun 2003 17:33:58 -0300 (ADT) Received: from kaos.securitymatrix.com ([172.16.0.101]) by smaug.securitymatrix.com (8.11.6/8.11.6) with ESMTP id h5GKXLV21252 for ; Mon, 16 Jun 2003 16:33:21 -0400 Subject: Postgres Connections Requiring Large Amounts of Memory From: Dawn Hollingsworth To: pgsql-performance@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 16 Jun 2003 08:32:17 +0000 Message-Id: <1055752337.2182.49.camel@kaos> Mime-Version: 1.0 X-Archive-Number: 200306/98 X-Sequence-Number: 2182 PostgreSQL Version: 7.2.3 OS : Red Hat 7.3 with Kernel 2.4.18-5 and SGI_XFS I currently have two processes which create several persistent connections to the database. One process primarily does inserts and the other primarily does selects. Both processes run 24/7. My problem is that the memory used by the connections appears to grow over time, especially when the amount of data entering the system is increased. The connections sometimes take up wards of 450 MB of memory causing other applications on the system to swap. Is there anyway to limit the amount of memory used by a given connection or is there something I may be doing that is requiring the connection to need more memory? -Dawn