Re: can't shrink relation

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: can't shrink relation
Date: 2007-10-04 10:11:48
Message-ID: 87abqzyysb.fsf@mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Henrik 2007-10-04 10:15:04 Re: Query taking too long. Problem reading explain output.
Previous Message Sabin Coanda 2007-10-04 09:46:02 Re: can't shrink relation