Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1pPTFj-0003lu-O1
	for pgsql-admin@arkaria.postgresql.org; Tue, 07 Feb 2023 19:03:39 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1pPTFi-0004EV-Gc
	for pgsql-admin@arkaria.postgresql.org; Tue, 07 Feb 2023 19:03:38 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1pPTFi-0004EM-5O
	for pgsql-admin@lists.postgresql.org; Tue, 07 Feb 2023 19:03:38 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1pPTFg-0004WH-2R
	for pgsql-admin@postgresql.org; Tue, 07 Feb 2023 19:03:37 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 317J3VR43215332;
	Tue, 7 Feb 2023 14:03:31 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Erik Serrano <eserranos@gmail.com>
cc: Holger Jakobs <holger@jakobs.com>,
        pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Vacuum Full not clean the table
In-reply-to: 
 <CA+dvXXu1OMaJviuJ3vZhq-3Qe2EFEfRsQkTrdA+HviU-A1LV8w@mail.gmail.com>
References: 
 <CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com>
 <8aacabc6-5919-5f37-9c9a-2a3cd67adfa3@jakobs.com>
 <CA+dvXXu1OMaJviuJ3vZhq-3Qe2EFEfRsQkTrdA+HviU-A1LV8w@mail.gmail.com>
Comments: In-reply-to Erik Serrano <eserranos@gmail.com>
	message dated "Tue, 07 Feb 2023 15:45:02 -0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3215330.1675796611.1@sss.pgh.pa.us>
Date: Tue, 07 Feb 2023 14:03:31 -0500
Message-ID: <3215331.1675796611@sss.pgh.pa.us>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/3215331.1675796611%40sss.pgh.pa.us>
Precedence: bulk

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