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

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

From: tuanhoanganh <hatuan05(at)gmail(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Date: 2010-12-22 11:28:41
Message-ID: AANLkTikWVK4nn5vpSqwx81EqD+Y5yVY6_OuJ2DoLyonb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
As far as i know, Pgbouncer can help to minimum connect to postgresql, I
want tool can open and keep 200 connect to postgresql (be cause start new
connect to postgresql in windows very slow, i want it open 200 connect in
first time and my application connect to this tool)

Is there any tool like that in windows.

Thanks for you help.

Tuan Hoang ANh.

On Tue, Dec 21, 2010 at 3:43 PM, Magnus Hagander <magnus(at)hagander(dot)net>wrote:

> 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: Gurjeet SinghDate: 2010-12-22 12:13:56
Subject: Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question?
Previous:From: Marti RaudseppDate: 2010-12-22 10:58:33
Subject: Re: MySQL HandlerSocket - Is this possible in PG?

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