From: | Erik Serrano <eserranos(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Vacuum Full not clean the table |
Date: | 2023-02-07 16:51:43 |
Message-ID: | CA+dvXXu2krLsS3K_GJkdrCT1hbu+G0rxAjh1KKot5TGrBpn8AA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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*
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2023-02-07 16:56:22 | Re: Vacuum Full not clean the table |
Previous Message | Sachin Kumar | 2023-02-05 18:02:23 | Re: Postgres Monitoring |