Hello,
I suggest that you read Adam Eckerle's posts on "Getting Comfortable with VProstgres and the VCSA":
Part 1: Getting Comfortable with vPostgres and the vCenter Server Appliance - Part 1 - VMware vSphere Blog
Part 2: http://blogs.vmware.com/vsphere/2016/05/getting-comfortable-with-vpostgres-and-the-vcenter-server-ap...
It may answer some of the questions that you have. PostgreSQL has a feature called "autovacuum" that is also used by the VCSA. That probably takes care of the cleanup work.
- Andreas
Twitter: @VFrontDe, @ESXiPatches | https://esxi-patches.v-front.de | https://vibsdepot.v-front.de
