Re: PostgreSQL run as process in windows

Поиск
Список
Период
Сортировка
От tuanhoanganh
Тема Re: PostgreSQL run as process in windows
Дата
Msg-id CAJg-yaNsFRkcJYZJDW+CYX+sU4PG_1=EN=4HxnZ5cf+YafLM3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL run as process in windows  (Craig Ringer <craig@2ndQuadrant.com>)
Ответы Re: PostgreSQL run as process in windows  (Craig Ringer <craig@2ndQuadrant.com>)
Список pgsql-general
On Thu, Jan 3, 2013 at 10:45 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
Running PostgreSQL directly via pg_ctl, not as a service, will not
change how it performs under load at all. It will not help you service
more than 500 concurrent connections.

You really need to put a connection pool in place to limit the number of
concurrent workers. Look at PgBouncer or PgPool-II. As far as I know
neither of them runs on Windows; you might want to think about a Linux
box as a front-end.

Thanks for your help. But when use PgBouncer, it run as service and may be it only support 512 connect (Because windows service only support default 125 connect, change registry windows can support 512 connect).
Is there any other way?

Thanks you very much (Sorry for my English)

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: PostgreSQL run as process in windows
Следующее
От: tuanhoanganh
Дата:
Сообщение: Re: PostgreSQL run as process in windows