Re: Vacuum Full not clean the table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Erik Serrano <eserranos(at)gmail(dot)com>
Cc: Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Vacuum Full not clean the table
Date: 2023-02-07 19:03:31
Message-ID: 3215331.1675796611@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Serrano 2023-02-07 21:36:30 Re: Vacuum Full not clean the table
Previous Message Erik Serrano 2023-02-07 18:59:00 Re: Vacuum Full not clean the table