Erik Serrano <eserranos@gmail.com> writes:
> For this reason, I appreciate that you can even guide me to see what is
> happening or could have happened regarding the end of the process without
> the expected result, which is cleaning the table.
If vacuum isn't removing dead tuples, it's because there is an open
transaction somewhere that can still "see" those tuples. Check for
old open transactions in pg_stat_activity and pg_prepared_xacts.
regards, tom lane
