Postgres Pro
Downloads
Home   >   mailing lists

Re: can't shrink relation - Mailing list pgsql-performance

From Sabin Coanda
Subject Re: can't shrink relation
Date
Msg-id fe2coo$187l$1@news.hub.org
Whole thread Raw
In response to can't shrink relation  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
Responses Re: can't shrink relation
Re: can't shrink relation
List pgsql-performance
Tree view 
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 ?

I notice that I don't get such messages when I run just VACUUM without FULL
option.

TIA,
Sabin

pgsql-performance by date:

Previous
From: "Sabin Coanda"
Date:
Subject: can't shrink relation
Next
From: Henrik
Date:
Subject: Re: Query taking too long. Problem reading explain output.