-----BEGIN PGP SIGNED MESSAGE----- Could anyone explain about the max_connections in postgres?
We ran into the connection limit on one of our production servers. One reason is that we have more apps that use postgres running on it (RT3 and Webcollab were added not long ago). Webcollab, for instance, seems to keep 7 postmaster processes all to itself. Is this normal? Does postgres work similarly to how apache handles spawning spare servers? I notice also on my test server, that 7 postmaster processes for webcollab are running, even though I'm the only one who has used it, and not all that heavily, and they haven't been touched for two days. # ps -U pgsql -ax -o pid,ppid,start,time,command PID PPID STARTED TIME COMMAND 4876 1 18Aug03 0:08.35 /usr/local/bin/postmaster (postgres) 4880 4876 18Aug03 0:00.04 postmaster: stats buffer process (postgres) 4881 4880 18Aug03 0:00.18 postmaster: stats collector process (postgres) 24053 4876 Tue11AM 0:00.09 postmaster: webcollab webcollab [local] idle (postgres) 24054 4876 Tue11AM 0:00.06 postmaster: rt3 rt3 127.0.0.1 idle (postgres) 24060 4876 Tue11AM 0:00.05 postmaster: rt3 rt3 127.0.0.1 idle (postgres) 24062 4876 Tue11AM 0:00.09 postmaster: webcollab webcollab [local] idle (postgres) 24230 4876 Tue02PM 0:00.05 postmaster: webcollab webcollab [local] idle (postgres) 24231 4876 Tue02PM 0:00.53 postmaster: webcollab webcollab [local] idle (postgres) 24236 4876 Tue02PM 0:00.44 postmaster: webcollab webcollab [local] idle (postgres) 24237 4876 Tue02PM 0:01.35 postmaster: webcollab webcollab [local] idle (postgres) 24238 4876 Tue02PM 0:02.45 postmaster: webcollab webcollab [local] idle (postgres) Could anyone enlighten me? I already tried digging through various docs and list archives, but didn't turn up much. If you could point me to some specific reading that would be appreciated as well. Thanx! ~~ Andy Harrison (full headers for details) -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBP1dTU1PEkLgodAWVAQEBsQP+PVWFjjmObUhVvhpmcS6riJ+ktKSrpbtx /iGGmTavdI2cbNhZTVqD3Jtnmhfy6lmRsf7pB0Hd75UzMCkSUz4Bc/97D1YnPx4O /wa0YPwx2xs3tmhaWRt99yU3YUqNKUmrwuNkNXKj+4vEyN1u3CDOmmvb+fitl9bi Sxhe2ZHi8wo= =lLaV -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
