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