Re: Per thread Connection memory

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(at)gmail(dot)com> 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
>
>