#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Posts
    1
    Rep Power
    0

    Unhappy PgSQL can't accept too much connections


    Hi guys,

    We just did a stress test on our web server. Approximately 30 minutes into the test, when number of concurrent users (60 users at this time) are increased, PHP would not connect to PostgreSQL.

    Why does PosgreSQL shuts itself down for additional connections?

    Any help would be much appreciated.
    Joe
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    PostgreSQL's default settings are pretty conservative, so it can even be installed on a low-end machine. There is a hard limit to the number of concurrent users, that can be changed in postgresql.conf.

    Here are a few other good links for tuning PostgreSQL:

    http://www.phpbuilder.com/columns/smith20010821.php3

    http://www.ca.postgresql.org/docs/mo...w_performance/

    http://techdocs.postgresql.org/techd...qldbtuning.php
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com

IMN logo majestic logo threadwatch logo seochat tools logo