Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id F2BF5632D9B for ; Wed, 16 Jun 2010 16:13:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 40029-03-3 for ; Wed, 16 Jun 2010 19:13:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tutopia.com (mail04mass.ifxnetworks.com [190.60.24.74]) by mail.postgresql.org (Postfix) with ESMTP id D1A2F633B17 for ; Wed, 16 Jun 2010 16:12:49 -0300 (ADT) Received: (qmail 9451 invoked from network); 16 Jun 2010 13:46:08 -0000 Received: from unknown (HELO mail12.ifxnetworks.com) ([190.61.128.22]) (envelope-sender ) by mail04mass.ifxnetworks.com (qmail-ldap-1.03) with SMTP for ; 16 Jun 2010 13:45:57 -0000 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" MIME-Version: 1.0 From: Juan Pablo Sandoval Rivera To: pgsql-performance@postgresql.org Subject: Confirm calculus Reply-To: juapabsan@tutopia.com X-Origin: 190.60.24.4 Date: Wed, 16 Jun 2010 13:45:57 +0000 X-Uidl: 1276695956192594799 X-Mailer: AtMail 4.11 Message-Id: <20100616191249.D1A2F633B17@mail.postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/287 X-Sequence-Number: 39143 Good morning List =0D =0D In relation to the process of tuning the engine PostgreSQL database, especi= ally =0D 7.3.7 version that is being used currently, agreaceria me clarify a procedu= re =0D =0D If I have a server with 2 GB of RAM, it is said that the shared memory segm= ent for =0D the engine of the database on a dedicated server should be between 25% and = maximum 33% of the RAM. =0D =0D I'm doing the calculation would be the next agradeze I confirm if I am =0D correct =0D =0D 1 MB =3D 1,048,576 =0D * 2 =3D 2097152 1048576 =0D 25% would be 2097152 * 25 / 100 =3D 524288 =0D Then the shared_buffers should be 524288 / 8 =3D 65536 for 25% of 2 GB =0D or should be 524 288? =0D =0D =0D Sincerely.=0D =0D Juan Pablo Sandoval Rivera=0D Tecnologo Prof. en Ing. de Sistemas=0D =0D Linux User : 322765 =0D msn : juan_pablos@hotmail.com=0D yahoo : juan_pablos@rocketmail.com (juan_pablos.rm)=0D UIN : 276125187 (ICQ)=0D Jabber : juan_pablos@www.jabberES.org=0D Skype : juan.pablo.sandoval.rivera=0D =0D APOYA A ECOSEARCH.COM - Ayuda a salvar al Planeta.=0D =0D =0D =0D