Dmitry Tkach <dmitry(at)openratings(dot)com> writes:
> By closing other transactions, did you mean ALL transactions open in
> that database, or just the ones, having anything to do with that table
> (reading/writing)?
I mean ALL.
You can start some new ones right away, but your current open
transactions are determining what VACUUM thinks might be a still-visible
tuple. You need to make the "oldest open transaction number" move
forward.
regards, tom lane