Hi ,
For 16 GB Ram 8 core CPU , My Postgresql configuration are as below
listen_addresses = '*' # what IP address(es) to listen on;
max_connections = 1000 # (change requires restart)
shared_buffers = 5GB # min 128kB
dynamic_shared_memory_type = posix # the default is the first option
effective_cache_size = 4GB
log_destination = 'stderr' # Valid values are combinations of
logging_collector = on # Enable capturing of stderr and csvlog
log_directory = 'pg_log' # directory where log files are written,
log_filename = 'postgresql-%a.log' # log file name pattern,
log_truncate_on_rotation = on # If on, an existing log file with the
log_rotation_age = 1d # Automatic rotation of logfiles will
log_rotation_size = 0 # Automatic rotation of logfiles will
log_min_duration_statement = 100 # -1 is disabled, 0 logs all statements
log_line_prefix = '< %m >' # special values:
log_timezone = 'Asia/Kolkata'
datestyle = 'iso, mdy'
timezone = 'Asia/Kolkata'
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
I Am Monitoring the Connection for postgresql
while true; do (ps auxxx | grep postgres |wc -l); sleep 2; done
Per sec as connection grows near to 180 , Need to restart Tomcat .
Is PostgreSQL Take per thread Memory to0 High to assign
