El mar, 7 feb 2023 a las 16:03, Tom Lane (<tgl@sss.pgh.pa.us>) escribió:
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.