Re: Explanantion on pgbouncer please

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: Explanantion on pgbouncer please
Дата
Msg-id CAMjNa7finH-F-r-0dnb0=0y8Um7oYVNUU08Fa8PadNjk31Tt+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Explanantion on pgbouncer please  (si24 <smrcoutts24@gmail.com>)
Список pgsql-general
For where you are measuring, everything looks normal to me.


Your application will make connections to the pooler as needed, and the pooler will assign the application connection to a database connection it has available in it's pool.  This gets rid of the overhead of creating a brand new connection to the DB right from the application for a small query, as connecting to the pooler is much less overhead.

The pooler should eventually get to the maximum number of allowed connections.  That is just how it's supposed to work.  It is not supposed to any connections after your application doesn't need the them any more.  It just keeps it open, and adds it to the available pool for your application to use.


On Thu, Oct 31, 2013 at 10:49 AM, si24 <smrcoutts24@gmail.com> wrote:
I use a check in postgres to give the active connections being used.

But what happens if the connection pooler goes all the way to 100 for
example and say that 100 is your postgres maximum connections at the time. I
know I can change the maximum connections in postgres but am not to sure on
the right balance. If I have say 600 people looking at my map is that not
then several calles to postgres to show them the map that each person is
looking at on the computer?



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Explanantion-on-pgbouncer-please-tp5776515p5776524.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: si24
Дата:
Сообщение: Re: Explanantion on pgbouncer please
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Table with Field Serial - Problem