X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C80389FB762 for ; Fri, 1 Sep 2006 17:04:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 24943-02-7 for ; Fri, 1 Sep 2006 17:04:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B92539FB91E for ; Fri, 1 Sep 2006 14:35:21 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k81HZKjx012757; Fri, 1 Sep 2006 13:35:20 -0400 (EDT) To: Matteo Sgalaberni cc: pgsql-performance@postgresql.org Subject: Re: database bloat,non removovable rows, slow query etc... In-reply-to: <20060901172829.GX2266@sgala.com> References: <20060901123915.GT2266@sgala.com> <4027.1157121810@sss.pgh.pa.us> <20060901172829.GX2266@sgala.com> Comments: In-reply-to Matteo Sgalaberni message dated "Fri, 01 Sep 2006 19:28:29 +0200" Date: Fri, 01 Sep 2006 13:35:20 -0400 Message-ID: <12756.1157132120@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.126 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/7 X-Sequence-Number: 20693 Matteo Sgalaberni writes: > Ok. I stopped all clients. No connections to this database. When you say "this database", do you mean the whole postmaster cluster, or just the one database? Open transactions in other databases of the same cluster can be a problem. regards, tom lane