Re: [PERFORM] can't shrink relation

2007-10-04 Thread Guillaume Cottenceau
"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 shr

Re: [PERFORM] can't shrink relation

2007-10-04 Thread Richard Huxton
Sabin Coanda wrote: sorry for the previous incomplete post. I continue with the log: Not really a performance question, this. Perhaps general/admin lists would be better next time. No matter... NOTICE: relation "pg_shdepend" TID 11/1: DeleteTransactionInProgress 2657075 --- can't shrink re

[PERFORM] can't shrink relation

2007-10-04 Thread Sabin Coanda
Hi there, I have a database with lowest possible activity. I run VACUUM FULL AND I get the following log result: ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your jo

Re: [PERFORM] can't shrink relation

2007-10-04 Thread Sabin Coanda
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