From: Guillaume Cottenceau <gc@mnc.ch>
To: Sabin Coanda <sabin.coanda@deuromedia.ro>
Cc: pgsql-performance@postgresql.org
Subject: Re: can't shrink relation
Date: Thu, 04 Oct 2007 12:11:48 +0200
Message-ID: <87abqzyysb.fsf@mnc.ch> (raw)
In-Reply-To: <fe2coo$187l$1@news.hub.org>
References: <fe2cj6$126i$1@news.hub.org>
<fe2coo$187l$1@news.hub.org>
"Sabin Coanda" <sabin.coanda 'at' deuromedia.ro> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gc@mnc.ch, sabin.coanda@deuromedia.ro
Subject: Re: can't shrink relation
In-Reply-To: <87abqzyysb.fsf@mnc.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox