On Tue, Dec 21, 2010 at 04:35, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Mon, Dec 20, 2010 at 8:31 PM, tuanhoanganh <hatuan05(at)gmail(dot)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...
In response to
pgsql-performance by date
|Next:||From: Michael Ben-Nes||Date: 2010-12-21 09:09:53|
|Subject: MySQL HandlerSocket - Is this possible in PG?|
|Previous:||From: Scott Marlowe||Date: 2010-12-21 03:35:29|
|Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?|