francescoboccacci at libero.it francescoboccacci at libero.it
Tue Apr 19 07:03:02 PDT 2011
Hi,
i write ps aux | grep postgres in my server:


postgres 32591  0.0  0.0 2230272 36900 ?       Ss   Apr14   1:34 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32593  0.0  0.1 2228152 67096 ?       Ss   Apr14   1:16 postgres: 
navmap grade2 [local] 
idle                                                         
postgres 32594  0.0  0.0 2225652 3920 ?        Ss   Apr14   0:00 postgres: 
navmap grade2 [local] 
idle                                                         
postgres 32595  0.0  0.2 2228340 189060 ?      Ss   Apr14   1:24 postgres: 
navmap grade2 [local] 
idle                                                         
postgres 32596  0.0  0.0 2225652 3792 ?        Ss   Apr14   0:00 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32603  0.0  0.0 2225652 3836 ?        Ss   Apr14   0:00 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32604  0.0  0.0 2225652 3836 ?        Ss   Apr14   0:00 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32605  0.0  0.2 2228344 181184 ?      Ss   Apr14   1:26 postgres: 
navmap grade4 [local] 
idle                                                         
postgres 32606  0.0  0.0 2225652 3864 ?        Ss   Apr14   0:00 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32608  0.0  0.0 2228156 63392 ?       Ss   Apr14   1:11 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32609  0.0  0.0 2225692 3764 ?        Ss   Apr14   0:00 postgres: 
navmap grade4 [local] 
idle                                                         
postgres 32610  0.0  0.0 2225692 3832 ?        Ss   Apr14   0:00 postgres: 
navmap grade4 [local] 
idle                                                         
postgres 32611  0.0  0.0 2230252 36960 ?       Ss   Apr14   1:34 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32612  0.0  0.9 2231704 604632 ?      Ss   Apr14   0:41 postgres: 
navmap grade4 [local] 
idle                                                         
postgres 32613  0.0  0.1 2228324 66780 ?       Ss   Apr14   1:12 postgres: 
navmap grade4 [local] 
idle                                                         
postgres 32614  0.0  0.0 2225692 3792 ?        Ss   Apr14   0:00 postgres: 
navmap grade4 [local] 
idle                                                         
postgres 32615  0.0  0.4 2231668 323880 ?      Ss   Apr14   0:25 postgres: 
navmap grade1 [local] 
idle                                                         
postgres 32616  0.0  0.2 2228340 188900 ?      Ss   Apr14   1:26 postgres: 
navmap grade9 [local] 
idle                                                         
postgres 32617  0.0  0.0 2225656 3696 ?        Ss   Apr14   0:00 postgres: 
navmap grade9 [local] 
idle                                                         


i saw many (about 40 porcess) like above rows

What's wrong?

Thanks

Francesco

>----Messaggio originale----
>Da: stephane.schildknecht at postgresql.fr
>Data: 19/04/2011 15.54
>A: <slony1-general at lists.slony.info>
>Ogg: Re: [Slony1-general] R: Re:  Too many idle process in my server
>
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Le 19/04/2011 15:27, francescoboccacci at libero.it a écrit :
>> Hi,
>> postgres.conf 
>> 
>> 
>> max_connections = 200 
>> 
>
>How do you configure your apps ?
>1 master and 4 slaves, that's (2 times the number of nodes + a few) 
connections
>established to your server.
>
>As far as I can tell, slony does not consume all connection slot here.
>
>You should have almost 180 left.
>
>
>- -- 
>Stéphane Schildknecht
>Loxodata
>Contact régional PostgreSQL
>
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.4.10 (GNU/Linux)
>Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
>iEYEARECAAYFAk2tlB0ACgkQA+REPKWGI0Fl+gCcCvWpGoru4V2NNAI30MzBZmbb
>UMYAn0IuRO4K/dgslrRArUG2HTGM3rMV
>=N4dg
>-----END PGP SIGNATURE-----
>_______________________________________________
>Slony1-general mailing list
>Slony1-general at lists.slony.info
>http://lists.slony.info/mailman/listinfo/slony1-general
>




More information about the Slony1-general mailing list