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 75EFD30EEC7 for ; Tue, 17 Jun 2003 23:21:53 +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 95055-09 for ; Tue, 17 Jun 2003 20:21:43 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id CE94C30DC8A for ; Tue, 17 Jun 2003 20:21:42 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5HNLgU6017570; Tue, 17 Jun 2003 19:21:42 -0400 (EDT) To: Dawn Hollingsworth Cc: pgsql-performance@postgresql.org, Ben Scherrey Subject: Re: Postgres Connections Requiring Large Amounts of Memory In-reply-to: <1055847810.2833.260.camel@kaos> References: <1055752337.2182.49.camel@kaos> <6634.1055796302@sss.pgh.pa.us> <1055753856.5467.57.camel@kaos> <6892.1055799269@sss.pgh.pa.us> <1055832411.5467.100.camel@kaos> <14875.1055878682@sss.pgh.pa.us> <1055842927.2182.227.camel@kaos> <15851.1055887425@sss.pgh.pa.us> <1055847810.2833.260.camel@kaos> Comments: In-reply-to Dawn Hollingsworth message dated "17 Jun 2003 11:03:28 -0000" Date: Tue, 17 Jun 2003 19:21:41 -0400 Message-ID: <17569.1055892101@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/120 X-Sequence-Number: 2204 Dawn Hollingsworth writes: > I just connected the user interface to the database. It only does > selects on startup. It's connection jumped to a memory usage of 256M. > It's not getting any larger but it's not getting any smaller either. Um, are you sure that's actual memory usage? On some platforms "top" seems to count the Postgres shared memory block as part of the address space of each backend. How big is your shared memory block? (ipcs may help here) regards, tom lane