On Tue, Dec 21, 2010 at 04:35, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Dec 20, 2010 at 8:31 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
>> Is there any tool work on windows can open 200 connect to postgresql and
>> application connect to this tool to decrease time connect to PostgreSQL
>> (because PostgreSQL start new process when have a new connect, I want this
>> tool open and keep 200 connect to postgreSQL, my application connect to this
>> tool instead of postgreSQL).
>
> Sure, that's what any good pooler can do. Have it open and hold open
> 200 connections, then have your app connect to the pooler. The pooler
> keeps the connects open all the time. The app connects to a much
> faster mechanism, the pooler each time. You need to make sure your
> connections are "clean" when you disconnect, i.e. no idle transactions
> left over, or you'll get weird errors about failed transactions til
> rollback etc.
Yeah, AFAIK pgbouncer works fine on Windows, and is a very good pooler
for PostgreSQL. I haven't run it on Windows myself, but it should
support it fine...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/