Re: Vacuum Full not clean the table

thanks Tom , Holder

*Erik R. Serrano Saavedra*
*Ingeniero de Sistemas Informáticos*
* Data Base Administrator*

* eserranos(at)gmail(dot)com <eserranos(at)gmail(dot)com>*
* 998596691*

El mar, 7 feb 2023 a las 16:03, Tom Lane (<tgl(at)sss(dot)pgh(dot)pa(dot)us>) escribió:

> Erik Serrano <eserranos(at)gmail(dot)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
>