Skip site navigation (1) Skip section navigation (2)

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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: tuanhoanganh <hatuan05(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date: 2010-12-21 08:43:50
Message-ID: AANLkTimTsW-w6w1561KRnUuuW9+26JncVQFu0rSo+0Ww@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

Responses

pgsql-performance by date

Next:From: Michael Ben-NesDate: 2010-12-21 09:09:53
Subject: MySQL HandlerSocket - Is this possible in PG?
Previous:From: Scott MarloweDate: 2010-12-21 03:35:29
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group