| From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Maintenance |
| Date: | 2024-05-08 12:02:45 |
| Message-ID: | 8f36cff9-78aa-4e72-ab22-093a889a926d@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Sunil Jadhav schrieb am 08.05.2024 um 11:17:
> We have a 12TB db and one table having around 7 TB data , is there
> any option we can removed the dead tuple and size also increase for
> that partition without downtime . Vaccum full we can't do because of
> exclusive lock in tables during processing.
>
> We have critical application so don't get the downtown so how to
> achieve this please let us know
Have a look at pg_squeeze or pg_repack but both will create a copy of the table,
so if you don't have enough free disk space neither is an option.
You probably also want to investigate if making autovacuum more aggressive
helps
Did you validate that those dead tuples you see really are a problem and
are not re-used?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Kamau | 2024-05-08 12:12:36 | Locked account |
| Previous Message | Wasim Devale | 2024-05-08 09:31:32 | Re: Maintenance |