From jsomoza@pandasoftware.es Mon Feb 27 12:42:54 2006 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 41AEE9DC80C for ; Mon, 27 Feb 2006 08:42:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14828-05 for ; Mon, 27 Feb 2006 08:42:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bilbao.pandasoftware.es (unknown [62.14.249.71]) by postgresql.org (Postfix) with ESMTP id 0E5BA9DCAC4 for ; Mon, 27 Feb 2006 08:42:49 -0400 (AST) Received: from escorpexh05.pandasoftware.local (escorpext02 [192.168.100.182]) by bilbao.pandasoftware.es (Postfix) with ESMTP id 966AC1B34AF for ; Mon, 27 Feb 2006 13:42:32 +0100 (CET) Received: from ESCORPEXH03.pandasoftware.local ([172.16.0.70]) by escorpexh05.pandasoftware.local with Microsoft SMTPSVC(6.0.3790.211); Mon, 27 Feb 2006 13:42:52 +0100 Received: escorpexh03.pandasoftware.local 172.16.0.73 from 172.16.128.4 172.16.128.4 via HTTP with MS-WebStorage 6.5.6944 Received: from pndsoft by escorpexh03.pandasoftware.local; 27 Feb 2006 13:43:36 +0100 Subject: Setting the shared buffers From: Javier Somoza To: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary="=-XxeEkJty47c36Sq500Bz" Message-Id: <1141044216.1556.54.camel@pndsoft> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Mon, 27 Feb 2006 13:43:36 +0100 X-OriginalArrivalTime: 27 Feb 2006 12:42:52.0852 (UTC) FILETIME=[5333EF40:01C63B9B] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.598 required=5 tests=[AWL=0.096, HTML_MESSAGE=0.001, RAZOR2_CF_RANGE_51_100=0.5, RAZOR2_CF_RANGE_E8_51_100=1.5, RAZOR2_CHECK=0.5, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 2.598 X-Spam-Level: ** X-Archive-Number: 200602/413 X-Sequence-Number: 17399 --=-XxeEkJty47c36Sq500Bz Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi, How should i set this configuration? Depending on the memory? And then is it necessary to perform a benchmarking test? What did you do? Thx! =20 Javier Somoza Oficina de Direcci=F3n Estrat=E9gica mailto:jsomoza@pandasoftware.es Panda Software Buenos Aires, 12 48001 BILBAO - ESPA=D1A Tel=E9fono: 902 24 365 4 Fax: 94 424 46 97 http://www.pandasoftware.es Panda Software, una de las principales compa=F1=EDas desarrolladoras de soluciones de protecci=F3n contra virus e intrusos, presenta su nueva familia de soluciones. Todos los usuarios de ordenadores, desde las redes m=E1s grandes a los dom=E9sticos, disponen ahora de nuevos productos con excelentes tecnolog=EDas de seguridad. M=E1s informaci=F3n en: http://www.pandasoftware.es/productos =20 =A1Prot=E9jase ahora contra virus e intrusos! Pruebe gratis nuestros productos en http://www.pandasoftware.es/descargas/ =20 =20 =20 =20 =20 =20 =20 =20 --=-XxeEkJty47c36Sq500Bz Content-Type: text/html; charset=utf-8
            Hi,

            How should i set this configuration? Depending on the memory?
            And then is it necessary to perform a benchmarking test?

            What did you do?

            Thx!
           


Javier Somoza
Oficina de Dirección Estratégica

mailto:jsomoza@pandasoftware.es

Panda Software
Buenos Aires, 12
48001 BILBAO - ESPAÑA
Teléfono: 902 24 365 4
Fax:  94 424 46 97

http://www.pandasoftware.es
Panda Software, una de las principales compañías desarrolladoras de soluciones de protección contra virus e intrusos, presenta su nueva familia de soluciones. Todos los usuarios de ordenadores, desde las redes más grandes a los domésticos, disponen ahora de nuevos productos con excelentes tecnologías de seguridad. Más información en: http://www.pandasoftware.es/productos

¡Protéjase ahora contra virus e intrusos! Pruebe gratis nuestros productos en http://www.pandasoftware.es/descargas/








--=-XxeEkJty47c36Sq500Bz-- From kometen@gmail.com Mon Feb 27 13:17:34 2006 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9C39F9DC9D3 for ; Mon, 27 Feb 2006 09:17:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19537-06 for ; Mon, 27 Feb 2006 09:17:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.192]) by postgresql.org (Postfix) with ESMTP id 465129DCB50 for ; Mon, 27 Feb 2006 09:17:32 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so885968nzo for ; Mon, 27 Feb 2006 05:17:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=I3ZyR9iZtxHXTNyuFRjBNjRuZ3E0mcvt5O0/OvTQgg2TTpcHOAdA9cAQUBnEYKI3fZ3b42/sv41ogmz+uH9IekGAfZstx8hrjyV1VFODBrzpVlWYz4vDyhg3KMkosiDzEw36ZpwIAP8CFYyJ+QL+a+GGoAtcohloAUOoxAdZM60= Received: by 10.65.183.8 with SMTP id k8mr456711qbp; Mon, 27 Feb 2006 05:17:35 -0800 (PST) Received: by 10.65.216.18 with HTTP; Mon, 27 Feb 2006 05:17:35 -0800 (PST) Message-ID: Date: Mon, 27 Feb 2006 14:17:35 +0100 From: "Claus Guttesen" To: "Javier Somoza" Subject: Re: Setting the shared buffers Cc: pgsql-performance@postgresql.org In-Reply-To: <1141044216.1556.54.camel@pndsoft> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1305_376649.1141046255574" References: <1141044216.1556.54.camel@pndsoft> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200602/414 X-Sequence-Number: 17400 ------=_Part_1305_376649.1141046255574 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline > > How should i set this configuration? Depending on the memory? > And then is it necessary to perform a benchmarking test? I've set it to 'shared_buffers =3D 12288' with 8 GB RAM on postgresql 7.4.9= , FreeBSD 6.0. There is no exact size, depends on type of workload, server-OS etc. Adjust it up and down and see if your performance changes. regards Claus ------=_Part_1305_376649.1141046255574 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
  =           How should i set thi= s configuration? Depending on the memory?
            And then= is it necessary to perform a benchmarking test?

I've = set it to 'shared_buffers =3D 12288' with 8 GB RAM on postgresql 7.4.9, Fre= eBSD 6.0. There is no exact size, depends on type of workload, server-OS et= c. Adjust it up and down and see if your performance changes.

regards
Claus

------=_Part_1305_376649.1141046255574--