Re: Vacuum Full not clean the table

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
> */
> /*                 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