Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?

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...

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/