[Admin] Reclaim Space from 4 TB Database

Поиск
Список
Период
Сортировка
От Rahul Saha
Тема [Admin] Reclaim Space from 4 TB Database
Дата
Msg-id CAEQ0CJh+ybQzk==y8YE_E6QqqwFGMScoFaHUVfqdNV+WFODVug@mail.gmail.com
обсуждение исходный текст
Ответы Re: [Admin] Reclaim Space from 4 TB Database  (Rui DeSousa <rui@crazybean.net>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: Re: Master slave replication
Следующее
От: Pierre Ochsenbein
Дата:
Сообщение: PostgreSQL HA