Re: Connection pooling

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: si24 <smrcoutts24(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connection pooling
Date: 2013-10-30 14:32:51
Message-ID: A76B25F2823E954C9E45E32FA49D70EC4283B006@mail.corp.perceptron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of si24
> Sent: Wednesday, October 30, 2013 10:14 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Connection pooling
>
> I have geoserver connected to a postgres database and so far I have been
> reading that I would need some sort of connection pooling but how do I go
> about doing that when it seems most of the connection pooling
> aplications/programs seem to only run on linux. I have a windows machine.
>
> otherwise is there some other sort of way that i can get the connections to
> close if they are not being used so as not to use all the connection on
> postgresql which is currently at 100 even if I set the max connections to
> 10000 I don't think that's going to be enough and I don't think thats a proper
> way to solve the problem I am having currently.
>

PgBouncer works fine on Windows, and does pretty good job.

Regards,
Igor Neyman

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-10-30 14:33:53 Re: Connection pooling
Previous Message si24 2013-10-30 14:22:38 Re: Connection pooling