vCenter 6.0 - 16 vCPUs / 60 gigs memory . When I run TOP I see the INVSVC using about 45 gigs of the Memory. (see below) . Looking for any recommendations or settings I can check or verify to drop this number as the vCenter is running slow at times and hangs intermittently.
Connect to DB:
/opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB
Run this below query:
SELECT nspname || '.' || relname AS "relation",
pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
AND C.relkind <> 'i'
AND nspname !~ '^pg_toast'
ORDER BY pg_total_relation_size(C.oid) DESC
LIMIT 20;
Also, attach vpxd, vpxd-profiler and invsvc logs.