| From: | Rahul Saha <rahul(dot)blooming(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | [Admin] Reclaim Space from 4 TB Database |
| Date: | 2018-07-18 10:17:05 |
| Message-ID: | CAEQ0CJh+ybQzk==y8YE_E6QqqwFGMScoFaHUVfqdNV+WFODVug@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Experts,
Greetings !!
Background - PG version 9.4
Linux - Rhel
I have a scenario in production environment where the DB size is close to 4
TB and couple of tables are 1.5TB each.
Now, as the table are highly transactional therefore there is lot of bloat
in tables. While I run Vaccum Full in weekend when there is no incoming
connection, vacuum full never completes in 2 days.
Firstly, I wanted to know what are the factor I should consider to speed up
Vacuum Full process other than investing memory.
Secondly are there any other option to reclaim space. (Pg_repck is a
option). I am looking for more option if available.
Thank you everyone.
--
Thanks & Regards
Rahul Saha
+91 8806351116
Sent from my iPhone
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Ochsenbein | 2018-07-18 13:53:58 | PostgreSQL HA |
| Previous Message | Mariel Cherkassky | 2018-07-17 13:05:31 | Re: Master slave replication |