Re: Connection pool

Hi,
Regarding connection pooling...
I may actually not need connection pooling...

I have one service to write to db. The service receives one or more requests
at the same time from different modules.

When two requests are received at the same time, both of the requests will
use the same db connection resulting in an error:
Started transaction<READ COMMITTED> while transaction<READ COMMITTED> still
active

So what I did was to have dedicated db connections for each type of
request. All of these requests are also put in a queue for their respective
types so that they will wait for the previous request to finish.

Is this an acceptable solution? Because I tried pgbouncer and it actually
does not solve the scenario above....

On Mon, Sep 6, 2010 at 10:12 PM, Mark Gabriel Paylaga <mpaylaga(at)gmail(dot)com>wrote:

> Thanks! I'll look into it.
>
> On Mon, Sep 6, 2010 at 2:54 PM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> wrote:
> > Hi,
> >
> > On 6 September 2010 10:34, Mark Paylaga <mpaylaga(at)gmail(dot)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 connections for each request. The
> simple way to do it is to hardcode and create x number of connections. Is
> there a way to just 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(at)postgresql(dot)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(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802
> >
>