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