root@Joker [ ~ ]# \/opt\/vmware\/vpostgres\/current\/bin\/psql -d VCDB -U postgres
psql.bin (9.6.16 (VMware Postgres 9.6.16.0-15334897 release))
Type “help” for help.<\/p>\n\n\n\n
VCDB=# CREATE OR REPLACE FUNCTION event_full_cleanup_p ()
VCDB-# returns void as $$
VCDB$# DECLARE
VCDB$# event_partition VARCHAR (200);
VCDB$# BEGIN
VCDB$# TRUNCATE TABLE VPX_EVENT_PARTITION_LOOKUP;
VCDB$# –Truncate partitions
VCDB$# FOR part IN 1..92
VCDB$# LOOP
VCDB$# event_partition = ‘TRUNCATE TABLE VPX_EVENT_’ || CAST(part AS TEXT) || ‘ CASCADE ‘;
VCDB$# EXECUTE event_partition;
VCDB$# event_partition = ‘TRUNCATE TABLE VPX_EVENT_ARG_’ || CAST(part AS TEXT) || ‘ CASCADE ‘;
VCDB$# EXECUTE event_partition;
VCDB$# event_partition = ‘ANALYZE VPX_EVENT_’ || CAST(part AS TEXT);
VCDB$# EXECUTE event_partition;
VCDB$# event_partition = ‘ANALYZE VPX_EVENT_ARG_’ || CAST(part AS TEXT);
VCDB$# EXECUTE event_partition;
VCDB$# END LOOP;
VCDB$# TRUNCATE TABLE VPX_ENTITY_LAST_EVENT;
VCDB$# END
VCDB$# $$language plpgsql;
CREATE FUNCTION
VCDB=# select event_full_cleanup_p();<\/p>\n\n\n\n
event_full_cleanup_p<\/p>\n\n\n\n
————————————–<\/p>\n\n\n\n
(1 row)<\/p>\n\n\n\n
VCDB=# \\q<\/p>\n\n\n\n
<\/p>\n\n\n\n
This obv comes with no warantee or guarantee<\/p>\n\n\n\n
it reduced our \/storage\/seat size from <\/p>\n\n\n\n
\/dev\/mapper\/seat_vg-seat 9.8G 8.7G<\/strong> 513M 95% \/storage\/seat<\/p>\n\n\n\n to<\/p>\n\n\n\n \/dev\/mapper\/seat_vg-seat 9.8G 2.5G<\/strong> 6.8G 27% \/storage\/seat<\/p>\n\n\n\n the \/storage\/seat directory gets filled rather quickly if you run vCenter 6.7u3 unpatched for any length of time. <\/p>\n","protected":false},"excerpt":{"rendered":" root@Joker [ ~ ]# \/opt\/vmware\/vpostgres\/current\/bin\/psql -d VCDB -U postgrespsql.bin (9.6.16 (VMware Postgres 9.6.16.0-15334897 release))Type “help” for help. VCDB=# CREATE OR REPLACE FUNCTION event_full_cleanup_p ()VCDB-# returns void as $$VCDB$# DECLAREVCDB$# event_partition…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[125,124],"class_list":["post-819","post","type-post","status-publish","format-standard","hentry","category-uncategorised","tag-vcenter","tag-vmware"],"_links":{"self":[{"href":"https:\/\/increasec.com\/index.php?rest_route=\/wp\/v2\/posts\/819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/increasec.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/increasec.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/increasec.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/increasec.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=819"}],"version-history":[{"count":1,"href":"https:\/\/increasec.com\/index.php?rest_route=\/wp\/v2\/posts\/819\/revisions"}],"predecessor-version":[{"id":820,"href":"https:\/\/increasec.com\/index.php?rest_route=\/wp\/v2\/posts\/819\/revisions\/820"}],"wp:attachment":[{"href":"https:\/\/increasec.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/increasec.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/increasec.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}