/var/opt/rh/rh-postgresql10/lib/pgsql/data/postgresql.conf ---------------------------------------------------------- log_autovacuum_min_duration = '0' log_checkpoints = 'True' log_connections = 'True' log_disconnections = 'True' log_line_prefix = '%m [%r] [%p]: [l-%l] user=%u,db=%d,app=%a,e=%e, prcstm=%s ' log_lock_waits = 'True' log_min_duration_statement = 900 max_connections = 512 shared_buffers = 4800MB work_mem = 8MB maintenance_work_mem = 600MB effective_cache_size = 12000MB select * from pg_settings where name like 'autovacuum%';