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

[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

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 Guillaume Cottenceau
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