On 3/1/07, Shiva Sarna <shivasarna@yahoo.co.in> wrote:
> I am sorry if it is a repeat question but I want to know if database
> performance will decrease if I increase the max-connections to 2000. At
> present it is 100.
Most certainly. Adding connections over 200 will degrade performance
dramatically. You should look into pgpool or connection pooling from
the application.
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor |
jharris@enterprisedb.com
Iselin, New Jersey 08830 |
http://www.enterprisedb.com/
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate