From: Thorsten Schöning <tschoening@am-soft.de>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Per thread Connection memory
Date: Wed, 27 Jan 2016 15:33:53 +0100
Message-ID: <1690525.20160127153353@am-soft.de> (raw)
In-Reply-To: <CALXoLqzk5CkZq=tKvv=W+ugc43gr6Ug-ELo9HnjM9pxJ0Pm-FQ@mail.gmail.com>
References: <CALXoLqxVbxJy8DKqmACkyE_UFZpuL0L38102S-vM+6=eQ+FHng@mail.gmail.com>
<CAFe9ZTqe3_SqnCYbWhQe9Ve+mw+V+R=ksdr-r9DASZ4NSQu40Q@mail.gmail.com>
<CALXoLqzk5CkZq=tKvv=W+ugc43gr6Ug-ELo9HnjM9pxJ0Pm-FQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Guten Tag Ankur Kaushik,
am Mittwoch, 27. Januar 2016 um 12:09 schrieben Sie:
> Application Using Java Program , They have there java Pool system ,
> when this Java pool memory full , tomcat need to restart in every 30- 60 min
So why do you think your problem is with Postgres? Client side
connections out of Java are not influenced by server side Postgres
configuration and Tomcat and Postgres don't share any memory.
Sounds like you should provide the exact error message you get.
> Please Let me know in Postgresql pgbouncer is essential use for
> handling multithread applications ?
No and you already successfully use your setup, else you wouldn't run
into problems, your only problem is with available resources and how
to balance them. But first you need to know where exactly your
bottleneck is and it sounds more like Java/Tomcat to me.
Mit freundlichen Grüßen,
Thorsten Schöning
--
Thorsten Schöning E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/
Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04
AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tschoening@am-soft.de
Subject: Re: Per thread Connection memory
In-Reply-To: <1690525.20160127153353@am-soft.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox