Re: Vacuum Full not clean the table

Holger,

Sorry for my ignorance but the vacuum process can discriminate if the table
requires or not to delete its dead tuples ???
thanks

*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 15:47, Holger Jakobs (<holger(at)jakobs(dot)com>)
escribió:

> Am 07.02.23 um 19:45 schrieb Erik Serrano:
>
> Thank you very much Holger for answering, I'll tell you... regarding your
> question about whether it has enough provisioned space to be able to do the
> vacuum, yes... yes it does.
> Regarding your indication of the version we are working on, I know that
> 9.2 is out of all support and that its update is imminent... But that's how
> it is right now and I have to deal with it...
>
> 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.
>
> Thank you in advance for your help
>
>
> *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 13:56, Holger Jakobs (<holger(at)jakobs(dot)com>)
> escribió:
>
>> Am 07.02.23 um 17:51 schrieb Erik Serrano:
>>
>> Dear All,
>>
>> Along with saying hello, I would like to consult about a failure that is
>> happening to me with a PG 9.2 base and with a table that weighs 116GB and
>> its index 13Gb, mounted on a Linux Centos 7.2 with 4Core and 32Ram.
>> The failure occurs mainly in that I execute a Vacuum Full on the table
>> and it ends after 6 hours, but it does not clean anything. When checking
>> the dead tuples I realize that they follow the same dirty records in the
>> table. REF: (table of 420MM records with 20MM dead tuples)
>>
>> I hope you can guide me in finding a solution to clean that table.
>>
>> Greetings and many thanks to the Postgresql.org community
>> Atte.
>>
>>
>> *Erik Serrano*
>>
>>
>> Hi Erik,
>>
>> Does it end cleanly or with an error after 6 hours?
>>
>> Do you have enough disk space for the vacuum full? The old and the newly
>> written data have to exist at the same time. Only after a successful
>> vacuuming the old data get deleted.
>>
>> BTW, PG 9.2 has been out of service for quite some time. Only versions 11
>> to 15 are supported, with the support for version 11 lasting less than a
>> year.
>>
>> Kind Regards,
>>
>> Holger
>>
>> --
>> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>>
>> Scott Ribe is right, the percentage of dead tuples is not high. So there
> no real reason to change anything.
>
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>