setting shm memory for docker
next connect into db and add setting into alter system database …..
for optimize best commit is better red line !!!
ALTER SYSTEM SET max_connections = '64';
ALTER SYSTEM SET shared_buffers = '1GB';
ALTER SYSTEM SET effective_cache_size = '2GB';
ALTER SYSTEM SET work_mem = '256MB';
ALTER SYSTEM SET maintenance_work_mem = '1GB';
ALTER SYSTEM SET min_wal_size = '1GB';
ALTER SYSTEM SET max_wal_size = '2GB';
ALTER SYSTEM SET checkpoint_completion_target = '0.7';
ALTER SYSTEM SET wal_buffers = '16MB';
ALTER SYSTEM SET default_statistics_target = '100';
ALTER SYSTEM SET wal_sync_method = open_sync ;
ALTER SYSTEM SET synchronous_commit = off;
ALTER SYSTEM SET commit_delay = 60000;