>>> >>> User Access >>> Total Number of Users is 500 >>> Maximum number of Concurrent users will be 500 during peak time >>> Off Peak time the maximum number of concurrent user will be >>> around 150 to 200. >>> >> >>A connection pooler like pgpool or pgbouncer would considerably reduce the >>burden on your system. >> > >I am already using connection pooling in tomcat web server, so installing pgpool >will help enhancing the performance ?Any changes i have to do in my application to >include pgpool? > There shouldn't be need for another pooling solution. Anyway, you probably dont want 1800 concurrent connections on your database server, nor even get near that number. Check the number of actual connections with: select count(*) from pg_stat_activity; A vmstat run during high loads could provide a hindsight to if the number of connections is straining your server. If the number of connections is high (say over 200-300), try reducing the pool size in Tomcat and see what happens. You possibly could do fine with something between 50 and 100 connections. Regards, Fernando. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
