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/ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
