Case Archival on VACUUM tables space

General
, , ,
1

I ask this question about the description in the following document.

Pega Doc:
Pegasystems Documentation

(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.

2

I just comfirmed VACUUM was removed from 8.5.3, so running the pg_repack request through the PCS support team is needed.

3

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

4

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.