vcac database growing too large 7.x

First step is to check your postgres logs.

These are on /storage/db/pg_data/pg_log

more postgresql.log

You may find, ERROR,XX001,”could not read block 0 in file “”base/8198863/8987722″”: read only 0 of 8192 bytes”,,,,,”automatic vacuum of table “”vrhb.public.docs_core_authcredentialsservicestate”””,,,,””

The fix to stop your database from growing.

psql vrhb

reindex table vrhb.public.docs_core_authcredentialsservicestate;

vacuum full reindex table vrhb.public.docs_core_authcredentialsservicestate;

\c vcac

vacuum analyze;

\q

You can verify that the messages are gone from your postgresql.log