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

[tuanhoanganh <hatuan05@xxxxxxxxx>]

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@xxxxxxxxxxxx> wrote:

On Tue, Dec 21, 2010 at 04:35, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
> On Mon, Dec 20, 2010 at 8:31 PM, tuanhoanganh <hatuan05@xxxxxxxxx> 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/