Re: autovacuum can not remove dead tuples

Hello
And an additional question:

> [postgres:5543(at)ela] [04-03.17:27:09]=# select pid,state,substr(query,0,100) from pg_stat_activity where query ~ 'ela_elifeassist_product' ;
Have you another long transactions related not to this table?
Any long transaction will prevent vacuum. Vacuum can only delete rows older than the oldest transaction regardless relations. For example, transaction
begin;
select * from tablename1;
-- sleep 10 min
select * from another_tablename;
commit;
We must leave some dead rows in another_tablename for this 10 minutes because we do not know which rows are required in an open transaction later.

regards Sergei.