Per thread Connection memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux