Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F12BB9FB8F7 for ; Thu, 26 Jul 2007 13:07:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 37671-03 for ; Thu, 26 Jul 2007 13:07:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web33514.mail.mud.yahoo.com (web33514.mail.mud.yahoo.com [68.142.206.163]) by postgresql.org (Postfix) with SMTP id BA9FD9FB8C9 for ; Thu, 26 Jul 2007 13:07:12 -0300 (ADT) Received: (qmail 57920 invoked by uid 60001); 26 Jul 2007 16:07:11 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=1Rntmgan6v3wUeXgaz0nw77TZyhMRfS4p8AUlZbiZgo2T4VqgD5OvIkFWm4K6hkdxhk5hv5eKP2nHxZ6qv4hm6HF1WhwsKlOnHg0EpdsAvQz86Il5m1KyfETAYopyx4Etfc8LS9oPKvR1p11WI50xsN3Qbv5NjgWPAkwHcU+sOY=; X-YMail-OSG: mUd.BJcVM1ntoV6GsfZsn1Sx5wNSz3kn7YJDFR_HhoUtVbC53TuwuGm3AoEhoyaB986izcMM6sO85Q5E6qho1U9YDtD6peSpLwVUMVsuxfTCqyamW3boZjRYOq6pAQ-- Received: from [130.14.254.26] by web33514.mail.mud.yahoo.com via HTTP; Thu, 26 Jul 2007 09:07:11 PDT Date: Thu, 26 Jul 2007 09:07:11 -0700 (PDT) From: Bolotov Pavel Subject: postgresql fails to release memory To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <686975.57223.qm@web33514.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/297 X-Sequence-Number: 26278 Hi When postgresql releases connections ? i use postgresql on ubuntu server, run pg_dump mydb > db.out psql -d database -f db.out then run top and see more postgres processes. more pg_dump commands i run, less memory left Thanks Pavel. ____________________________________________________________________________________ Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. http://sims.yahoo.com/