Rajesh Kumar Mallah <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to