By default, all AtScale statements are logged into Postgres, which translates to very large log files.
This recommended approach will assist with debugging metadata-related errors and latency issues.
To log every single activity, log_min_duration_statement is set to 0.
The log_min_duration_statement can be set to > 0, which would help reduce the size of the Postgres logs if disk space is an issue.
Steps to follow to minimize Postgres logging:
1) Stop all the AtScale services /opt/atscale/bin/atscale_stop 2) Back up `/opt/atscale/data/database/postgresql.conf` for safekeeping 3) Edit `/opt/atscale/data/database/postgresql.conf` and set --log_min_duration_statement to log statements that take longer than 3 seconds. FROM : log_min_duration_statement = '0' TO : log_min_duration_statement = '3000' 4) Start up the AtScale services /opt/atscale/bin/atscale_start