Case Archival on VACUUM tables space
I ask this question about the description in the following document.
Pega Doc: https://docs-previous.pega.com/system-administration/85/case-archiving-and-purging-overview
(Diagram)Pega Cloud Case Archiving -> 3. Search and View Archived cases in PCFS:
Reclaim freed space by running pg_repack through the Pega Cloud Service support team.
pyPegaPurger:
The job also integrates a SQL VACUUM command to process deleted space and reclaim the irrelevant empty database tables.
Question:
VACUUM has the same functionality as pg_repack. Please clarify why we need a request to run pg_repack through the PCS support team.
CWT
PH
if pg_repack will be part of the process in maintaining the database cycle, what is the recommended interval of performing this pg_repack to reclaim deleted space?
thanks
Rommel
Pegasystems Inc.
JP
Running pg_repack will impact users, so is it better to do it off-peak system usage hours in the DB maintenance window. SRT will guide our Pega Cloud Clients. It should be run once a month or so, not more frequently, only after a vast amount of data has been archived.