Tue Apr 19 07:03:02 PDT 2011
- Previous message: [Slony1-general] R: Re: Too many idle process in my server
- Next message: [Slony1-general] Too many idle process in my server
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 >
- Previous message: [Slony1-general] R: Re: Too many idle process in my server
- Next message: [Slony1-general] Too many idle process in my server
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list