Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DC2F99F9498 for ; Thu, 4 Oct 2007 07:43:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 65374-09 for ; Thu, 4 Oct 2007 07:43:25 -0300 (ADT) X-Greylist: delayed 00:31:32.066426 by SQLgrey-1.7.5 Received: from mail.mnc.ch (62-2-77-205.static.cablecom.ch [62.2.77.205]) by postgresql.org (Postfix) with ESMTP id 8A3ED9F9492 for ; Thu, 4 Oct 2007 07:43:29 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.mnc.ch (Postfix) with ESMTP id 52BA1A82BD; Thu, 4 Oct 2007 12:12:08 +0200 (CEST) Received: from mail.mnc.ch ([127.0.0.1]) by localhost (mail.test.lan [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id 05320-06; Thu, 4 Oct 2007 12:12:05 +0200 (CEST) Received: from meuh.localdomain (62-2-77-204.static.cablecom.ch [62.2.77.204]) by mail.mnc.ch (Postfix) with ESMTP id B13BAA818A; Thu, 4 Oct 2007 12:12:05 +0200 (CEST) Received: by meuh.localdomain (Postfix, from userid 1000) id 9F747183720; Thu, 4 Oct 2007 12:11:48 +0200 (CEST) To: "Sabin Coanda" Cc: pgsql-performance@postgresql.org Subject: Re: can't shrink relation References: From: Guillaume Cottenceau X-Hashcash: 1:20:071004:sabin.coanda@deuromedia.ro::Nzy1K+8l7Btub5Zo:000000000000000000000000000000000007JSs X-Hashcash: 1:20:071004:pgsql-performance@postgresql.org::39ly71oZTppDa2X6:0000000000000000000000000000013U0 Date: Thu, 04 Oct 2007 12:11:48 +0200 In-Reply-To: (Sabin Coanda's message of "Thu\, 4 Oct 2007 12\:46\:02 +0300") Message-ID: <87abqzyysb.fsf@mnc.ch> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: amavisd-new at mnc.ch X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/27 X-Sequence-Number: 27049 "Sabin Coanda" writes: > sorry for the previous incomplete post. I continue with the log: > > NOTICE: relation "pg_shdepend" TID 11/1: DeleteTransactionInProgress > 2657075 --- can't shrink relation > NOTICE: relation "pg_shdepend" TID 11/2: DeleteTransactionInProgress > 2657075 --- can't shrink relation > ..... > NOTICE: relation "pg_shdepend" TID 36/93: DeleteTransactionInProgress > 2658105 --- can't shrink relation > > > What happen ? What I have to do ? You have to use google. First match to "postgresql can't shrink relation" (almost) returns: http://archives.postgresql.org/pgsql-novice/2002-12/msg00126.php -- Guillaume Cottenceau, MNC Mobile News Channel SA, an Alcatel-Lucent Company Av. de la Gare 10, 1003 Lausanne, Switzerland - direct +41 21 317 50 36