Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

How to Minimize AtScale Postgres Logging

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