Re: Per thread Connection memory

[Wei Shan <weishan.ang@xxxxxxxxx>]

Hi,

I'm not sure why do you need to restart tomcat? Could you explain further?

Also, max_connections=1000 is way too higher for 5GB of shared buffers. You could try setting it to 300 and put a connection pooler like pgbouncer infront

Thanks!

On 27 Jan 2016 15:29, "Ankur Kaushik" <ankurkaushik@xxxxxxxxx> wrote:

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