Re: Connection pooling - Mailing list pgsql-general

From Igor Neyman
Subject Re: Connection pooling
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC4283B006@mail.corp.perceptron.com
Whole thread Raw
In response to Connection pooling  (si24 <smrcoutts24@gmail.com>)
List pgsql-general

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of si24
> Sent: Wednesday, October 30, 2013 10:14 AM
> To: pgsql-general@postgresql.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


pgsql-general by date:

Previous
From: si24
Date:
Subject: Re: Connection pooling
Next
From: Adrian Klaver
Date:
Subject: Re: Connection pooling