Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80BBB64FFF4 for ; Wed, 12 Nov 2008 14:54:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84667-07 for ; Wed, 12 Nov 2008 14:54:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web52506.mail.re2.yahoo.com (web52506.mail.re2.yahoo.com [206.190.48.189]) by mail.postgresql.org (Postfix) with SMTP id 003CC64FE19 for ; Wed, 12 Nov 2008 14:54:26 -0400 (AST) Received: (qmail 17135 invoked by uid 60001); 12 Nov 2008 18:54:25 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=x+I7Af5H32o7haiv7LSjoX8V32um2x2L3qe9ThFvgR7F7y4HaQ2wvk15KBl0JX6B53cb/sBAjnI9NKyDmLz0rBt6FdAdpSIW9RhGK05RtNyLfYYSI5M7MGw2o34RbgTJJnAtmW0SBMkcaiLniO2qziRWkKR17j6eicKwDRYs/YM=; X-YMail-OSG: J8cuM0kVM1nrQAGPtGThvSDaS5StHbU1lWCdPVKyGv2l8huWpqKRlqMoGCOhlNf3GkrHyNOTYAyPytpiDdLWYZPlD0jZhyLJwYfa2l27kU05lFSYn_QPPTGR7UyqQoIGWr5vn_o7KPrRGXKW6PgSsBObSYT1NbDqs50lndRobvjTMeOAU14mYHEPVPD4eg-- Received: from [189.17.249.3] by web52506.mail.re2.yahoo.com via HTTP; Wed, 12 Nov 2008 10:54:24 PST X-Mailer: YahooMailRC/1155.29 YahooMailWebService/0.7.260.1 References: <234747.33153.qm@web52501.mail.re2.yahoo.com> <491B1532.10605@archonet.com> Date: Wed, 12 Nov 2008 10:54:24 -0800 (PST) From: paulo matadr Subject: Res: [GENERAL] MAX_CONNECTIONS ?? To: Richard Huxton Cc: GENERAL , admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-171550369-1226516064=:16100" Message-ID: <950503.16100.qm@web52506.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200811/66 X-Sequence-Number: 30720 --0-171550369-1226516064=:16100 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Only kernel.shmmax have =0A=0Aimportance in this case?=0Aabout kernel.shmm= ax it has configured not by me.=0A=0A=0A=0A________________________________= =0ADe: Richard Huxton =0APara: paulo matadr =0ACc: GENERAL ; admin =0AEnviadas: Quarta-feira, 12 de Novembro de 2008 14:41:06= =0AAssunto: Re: [ADMIN] [GENERAL] MAX_CONNECTIONS ??=0A=0Apaulo matadr wrot= e:=0A> I need help to alter max_connections em my database, this parameter= =0A> stay in defalt MAX_CONNECTIONS=3D100=0A> I want to change for MAX_CONN= ECTIONS=3D300. about parameters below,=0A> need to change anything?=0A> =0A= > 1 -sysctl.conf=0A> =0A> kernel.shmmax =3D 68719476736=0A> kernel.shmall = =3D 4294967296=0A=0ADoes your shmmax have one digit too many? 68GB?=0A=0A> = # - Memory -=0A> =0A> 2-Postgresql.conf=0A> shared_buffers =3D 2048MB = =0A> temp_buffers =3D 12MB = =0A> work_mem =3D 12MB = =0A> maintenance_work_mem =3D 128MB =0A> max= _fsm_pages =3D 4000000 =0A> max_fsm_relation= s =3D 5000 =0A=0AShould be OK, depending on your work-load.=0A= =0AOne question - what do you plan on doing with 300 active connections?=0A= Unless you've got more than 100 processors in this machine you might=0Awant= to consider connection-pooling.=0A=0A-- =0A Richard Huxton=0A Archonet L= td=0A=0A-- =0ASent via pgsql-admin mailing list (pgsql-admin@postgresql.org= )=0ATo make changes to your subscription:=0Ahttp://www.postgresql.org/mailp= ref/pgsql-admin=0A=0A=0A=0A Novos endere=C3=A7os, o Yahoo! que voc=C3= =AA conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.co= m.=0Ahttp://br.new.mail.yahoo.com/addresses --0-171550369-1226516064=:16100 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Only kernel.shmmax have
importance in this case?
about kernel.shmmax it has configured= not by me.

<= span style=3D"font-weight: bold;">De: Richard Huxton <dev@arc= honet.com>
Para: pau= lo matadr <saddoness@yahoo.com.br>
Cc: GENERAL <pgsql-general@postgresql.org>; admin &= lt;pgsql-admin@postgresql.org>
= Enviadas: Quarta-feira, 12 de Novembro de 2008 14:41:06
Assunto: Re: [ADMIN] [GENERAL] MAX= _CONNECTIONS ??

paulo matadr wrote:
> I need help to al= ter max_connections em my database, this parameter
> stay in defalt M= AX_CONNECTIONS=3D100
> I want to change for MAX_CONNECTIONS=3D300. ab= out parameters below,
> need to change anything?
>
> 1 -= sysctl.conf
>
> kernel.shmmax =3D 68719476736
> kernel.s= hmall =3D 4294967296

Does your shmmax have one digit too many? 68GB?=

> # - Memory -
>
> 2-Postgresql.conf
> shared= _buffers =3D 2048MB                =                      = ;    
> temp_buffers =3D 12MB        &= nbsp;                    =                     &nbs= p;
> work_mem =3D 12MB             =      
> maintenance_work_mem =3D 128MB   =                     &nbs= p;
> max_fsm_pages =3D  4000000        &nb= sp;                     =
> max_fsm_relations =3D 5000           = ;

Should be OK, depending on your work-load.

One question - = what do you plan on doing with 300 active connections?
Unless you've got= more than 100 processors in this machine you might
want to consider con= nection-pooling.

--
  Richard Huxton
  Archonet Ltd=

--
Sent via pgsql-admin mailing list (pgsql-ad= min@postgresql.org)
To make changes to your subscription:
= http://www.postgresql.org/mailpref/pgsql-admin
=0A=0A=0A
Novos endere=C3=A7os, o Yahoo! que voc=C3=AA c= onhece. Crie um email novo com a sua cara @ymail.com= ou @rocketmail.com. --0-171550369-1226516064=:16100--