Message-ID: <52266.192.168.207.54.1426624666.squirrel@webmail.etecsa.cu>
In-Reply-To: 
 <1932425765.521689.1426619005045.JavaMail.zimbra@mail.int.journyx.com>
References: <3378DD84AF4742E19DF2240E3AB9BED1@DeniDell>
 <1932425765.521689.1426619005045.JavaMail.zimbra@mail.int.journyx.com>
Date: Tue, 17 Mar 2015 15:37:46 -0500 (GMT+5)
Subject: 
 =?utf-8?B?UmU6IFtBRE1JTl0gUGFyw6JtZXRyb3MgcGFyYSBtZWxob3IgcGVyZm9ybWFu?=
 =?utf-8?B?Y2UgZG8gc2Vydmlkb3I=?=
From: "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
To: "Scott Whitney" <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Reply-To: gilberto.castillo@etecsa.cu
User-Agent: SquirrelMail/1.4.8-5.el5_4.10
MIME-Version: 1.0
Importance: Normal
Content-Type: multipart/mixed; boundary="=tEb04WGY46718=imx3.etecsa.cu="
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.

--=tEb04WGY46718=imx3.etecsa.cu=
Content-Disposition: inline
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


Use pg_tune in you server


> I hope you speak English, for my Portuguese is horrible. If not, I hope
> you can read English OK, because I certainly can't write well enough to
> ensure my information is accurate.
>
> From what I see, you're having performance issues, but you don't say what
> they are or how many people are accessing. Also, what version, precisely
> of 8.2 are you on?
>
> In general, performance comes down to two big things, from what I have
> seen: RAM and I/O.
>
> How many drives do you have, and in what configuration? 8GB RAM might or
> might not be enough overall, depending on what this server is doing, and 2
> processors might or might not be adequate for your usage.
>
> Can you provide a bit more information about your cluster, amount of data,
> drives and usage patterns?
>
> ----- On Mar 17, 2015, at 1:35 PM, Denilson Guedes Duarte
> <denilson@bnet.com.br> wrote:
>
>> Pessoal, estou precisando de umas dicas para melhorar a performance do
>> meu
>> servidor de banco de dados, agradeço desde já 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.
>> Tenho dois sistemas ERP que possuem muitos usuários simultâneos
>> acessando o
>> banco de dados, mais o Freeradius instalado para autenticar os meus
>> clientes do
>> provedor.
>> as especificações do servidor são:
>> 2 Processadores:
>> model name : Intel(R) Pentium(R) D CPU 2.80GHz
>> cpu MHz : 2400.000
>> cache size : 2048 KB
>> Memória:
>> MemTotal: 8309472 kB
>> MemFree: 1996996 kB
>> Buffers: 691172 kB
>> Cached: 5306644 kB
>> Shared Memory
>> /proc/sys/kernel/shmmax = 33554432 (32M)
>> /proc/sys/kernel/shmall = 2097152 (2M)
>> postgresql.conf:
>> max_connections = 100
>> shared_buffers = 24MB
>> max_fsm_pages = 153600
>
> Journyx, Inc.
>
> 7600 Burnet Road #300
>
> Austin, TX 78757
>
> www.journyx.com
>
>
>
> p 512.834.8888
>
> f 512.834.8858
>
> Do you receive our promotional emails? You can subscribe or unsubscribe to
> those emails at http://go.journyx.com/emailPreference/e/4932/714
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx2.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>


Saludos,
Gilberto Castillo
La Habana, Cuba

--=tEb04WGY46718=imx3.etecsa.cu=
Content-Type: text/plain
Content-Disposition: inline

--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

--=tEb04WGY46718=imx3.etecsa.cu=
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=tEb04WGY46718=imx3.etecsa.cu=--