Re: Connection pool - Mailing list pgsql-general

From Mark Gabriel Paylaga
Subject Re: Connection pool
Date
Msg-id AANLkTikS8FN=jWwie15srP6bs9UZaLNb11dzOB1cvhf7@mail.gmail.com
Whole thread Raw
In response to Re: Connection pool  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Connection pool  (Mark Gabriel Paylaga <mpaylaga@gmail.com>)
List pgsql-general
Thanks! I'll look into it.

On Mon, Sep 6, 2010 at 2:54 PM, Sergey Konoplev <gray.ru@gmail.com> wrote:
> Hi,
>
> On 6 September 2010 10:34, Mark Paylaga <mpaylaga@gmail.com> wrote:
>> Hi sorry if this has been asked already.
>> Is there any mechanism to do connection pooling for libpqxx already?
>> Or any new developments for this?
>>
>> Our one dbwriter service instance recieves requests simultaneously to write to the database. We need separate db
connectionsfor each request. The simple way to do it is to hardcode and create x number of connections. Is there a way
tojust use connection pooling? 
>
> There are two programs implementing connection pulling for PG. No need
> to implement it in your application.
>
> - pgbouncer (http://wiki.postgresql.org/wiki/PgBouncer)
> - pgpool (http://pgpool.projects.postgresql.org/)
>
>
>>
>>  Can anyone point me to the right direction? Thanks.
>>
>> Mark
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>
>
> --
> Sergey Konoplev
>
> Blog: http://gray-hemp.blogspot.com /
> Linkedin: http://ru.linkedin.com/in/grayhemp /
> JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802
>

pgsql-general by date:

Previous
From: Angus Miller
Date:
Subject: Re: Temporal'sh type sql question
Next
From: Piotr Rekowski
Date:
Subject: PostgreSQL dblink's way of manipulation with connections