Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43637=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YXwLQ-0000l6-Nk
 for pgsql-admin@arkaria.postgresql.org; Tue, 17 Mar 2015 18:36:00 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43637=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YXwLQ-0002MY-0c
 for pgsql-admin@arkaria.postgresql.org; Tue, 17 Mar 2015 18:36:00 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <denilson@bnet.com.br>)
 id 1YXwLO-0002K4-WD
 for pgsql-admin@postgresql.org; Tue, 17 Mar 2015 18:35:59 +0000
Received: from ns2.bnet.com.br ([187.102.80.6])
 by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <denilson@bnet.com.br>)
 id 1YXwLI-0005n0-7U
 for pgsql-admin@postgresql.org; Tue, 17 Mar 2015 18:35:57 +0000
Received: (qmail 88883 invoked from network); 17 Mar 2015 15:35:08 -0300
Received: by simscan 1.4.0 ppid: 88876, pid: 88879, t: 0.0378s
 scanners: clamav: 0.98.6/m:55/d:20120
Received: from unknown (HELO DeniDell) (denilson@bnet.com.br@[187.102.80.5])
 (envelope-sender <denilson@bnet.com.br>)
 by mail.bnet.com.br (qmail-ldap-1.03) with SMTP
 for <pgsql-admin@postgresql.org>; 17 Mar 2015 15:35:08 -0300
Message-ID: <3378DD84AF4742E19DF2240E3AB9BED1@DeniDell>
From: "Denilson Guedes Duarte" <denilson@bnet.com.br>
To: <pgsql-admin@postgresql.org>
Subject: =?iso-8859-1?Q?Par=E2metros_para_melhor_performance_do_servidor?=
Date: Tue, 17 Mar 2015 15:35:40 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----=_NextPart_000_0350_01D060C8.062AAC50"
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Mailer: Microsoft Windows Live Mail 15.4.3555.308
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3555.308
X-Pg-Spam-Score: 1.6 (+)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Esta é uma mensagem em várias partes no formato MIME.

------=_NextPart_000_0350_01D060C8.062AAC50
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Pessoal, estou precisando de umas dicas para melhorar a performance do =
meu servidor de banco de dados, agrade=E7o desde j=E1 quem puder =
contribuir.

Atualmente tenho um servidor com o PostGreSQL 8.2 rodando em um Dell =
PowerEdge 860 com o sistema operacional Linux Slacware v11.=20
Tenho dois sistemas ERP que possuem muitos usu=E1rios simult=E2neos =
acessando o banco de dados, mais o Freeradius instalado para autenticar =
os meus clientes do provedor.

as especifica=E7=F5es do servidor s=E3o:
2 Processadores:=20
    model name      : Intel(R) Pentium(R) D CPU 2.80GHz
    cpu MHz         : 2400.000
    cache size      : 2048 KB
Mem=F3ria:
    MemTotal:    8309472 kB
    MemFree:     1996996 kB
    Buffers:        691172 kB
    Cached:        5306644 kB
Shared Memory   =20
    /proc/sys/kernel/shmmax =3D 33554432 (32M)
    /proc/sys/kernel/shmall =3D  2097152  (2M)
postgresql.conf:
    max_connections =3D 100
    shared_buffers =3D 24MB
    max_fsm_pages =3D 153600

 
------=_NextPart_000_0350_01D060C8.062AAC50
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD></HEAD>
<BODY dir=3Dltr>
<DIV dir=3Dltr>
<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV>Pessoal, estou precisando de umas dicas para melhorar a performance =
do meu=20
servidor de banco de dados, agrade=E7o desde j=E1 quem puder =
contribuir.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Atualmente tenho um servidor com o PostGreSQL 8.2 rodando em um =
Dell=20
PowerEdge 860 com o sistema operacional Linux Slacware v11. </DIV>
<DIV>Tenho dois sistemas ERP que possuem muitos usu=E1rios simult=E2neos =
acessando o=20
banco de dados, mais o Freeradius instalado para autenticar os meus =
clientes do=20
provedor.</DIV>
<DIV>&nbsp;</DIV>
<DIV>as especifica=E7=F5es do servidor s=E3o:</DIV>
<DIV>2 Processadores: </DIV>
<DIV>&nbsp;&nbsp;&nbsp; model name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : =
Intel(R)=20
Pentium(R) D CPU 2.80GHz</DIV>
<DIV>&nbsp;&nbsp;&nbsp; cpu =
MHz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
: 2400.000</DIV>
<DIV>&nbsp;&nbsp;&nbsp; cache size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 2048 =
KB</DIV>
<DIV>Mem=F3ria:</DIV>
<DIV>&nbsp;&nbsp;&nbsp; MemTotal:&nbsp;&nbsp;&nbsp; 8309472=20
kB<BR>&nbsp;&nbsp;&nbsp; MemFree:&nbsp;&nbsp;&nbsp;&nbsp; 1996996=20
kB<BR>&nbsp;&nbsp;&nbsp; =
Buffers:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
691172 kB<BR>&nbsp;&nbsp;&nbsp;=20
Cached:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5306644 kB<BR>Shared=20
Memory&nbsp;&nbsp;&nbsp; </DIV>
<DIV>&nbsp;&nbsp;&nbsp; /proc/sys/kernel/shmmax =3D 33554432 (32M)</DIV>
<DIV>&nbsp;&nbsp;&nbsp; /proc/sys/kernel/shmall =3D&nbsp; 2097152&nbsp; =
(2M)</DIV>
<DIV>postgresql.conf:</DIV>
<DIV>&nbsp;&nbsp;&nbsp; max_connections =3D 100</DIV>
<DIV>&nbsp;&nbsp;&nbsp; shared_buffers =3D 24MB</DIV>
<DIV>&nbsp;&nbsp;&nbsp; max_fsm_pages =3D 153600</DIV>
<DIV>&nbsp;</DIV>
<DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000">
<DIV><A href=3D"https://www.facebook.com/bnet.oficial" =
target=3D_new><IMG border=3D0=20
src=3D"http://www.bnet.com.br/assinatura/denilson_01.jpg"></A><A=20
href=3D"http://www.bnet.com.br/" target=3D_new><IMG border=3D0=20
src=3D"http://www.bnet.com.br/assinatura/leandro_02.jpg"></A>=20
</DIV></DIV></DIV></DIV></BODY></HTML>

------=_NextPart_000_0350_01D060C8.062AAC50--