This page proposes a way to VACUUM FULL all the tables of a schema. This SQL command can help to improve the performance while executing queries, for more detailed description refer to Postgres - VACUUM
Applicable CAST Version
Query for CSS
Generate the Full vaccum queries:
SELECT 'vacuum full '
WHERE table_schema = 'delta_local'
ORDER BY table_schema,
where <hostname> is the host, <username> is the username, <schema_name> is the name of the schema <sql file generated in step 1> is the sql file generated in step 1, <log file> is log file that you can scpecified Exemple: