Subject: can't shrink relation
From: Sabin Coanda
Date: 10/4/2007 12:43:12 PM
Hi there,
I have a database with lowest possible activity. I run VACUUM FULL AND I get
the following log result:
Subject: can't shrink relation
From: Sabin Coanda
Date: 10/4/2007 12:46:02 PM
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
|