Re: New server setup

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: New server setup
Дата
Msg-id CAOR=d=3_KXQnE9PwMnmGJaVQ_8EVZietjjra1XR7iU2n8FDxKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: New server setup  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-performance
On Tue, Mar 5, 2013 at 9:34 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
> Niels Kristian Schjødt <nielskristian@autouncle.com> wrote:
>
>> So my question is, should I also get something like pgpool2 setup
>> at the same time? Is it, from your experience, likely to increase
>> my throughput a lot more, if I had a connection pool of eg. 20
>> connections, instead of 300 concurrent ones directly?
>
> In my experience, it can make a big difference.  If you are just
> using the pooler for this reason, and don't need any of the other
> features of pgpool, I suggest pgbouncer.  It is a simpler, more
> lightweight tool.

I second the pgbouncer rec.


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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: New server setup
Следующее
От: Niels Kristian Schjødt
Дата:
Сообщение: Re: New server setup