Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> I am sure there is no transaction open with the table banner_stats2.
> Still VACUUM FULL does not seems to effective in removing the
> dead rows.
That is not the issue --- the limiting factor is what is your oldest
open transaction, period. Whether it has yet looked at this table is
not relevant, because the system has no way to know whether it might
decide to do so later.
regards, tom lane