From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Parâmetros para melhor performance do servidor
Date: Tue, 17 Mar 2015 15:37:46 -0500 (GMT+5)
Message-ID: <52266.192.168.207.54.1426624666.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <1932425765.521689.1426619005045.JavaMail.zimbra@mail.int.journyx.com>
References: <3378DD84AF4742E19DF2240E3AB9BED1@DeniDell>
<1932425765.521689.1426619005045.JavaMail.zimbra@mail.int.journyx.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
---
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;
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gilberto.castillo@etecsa.cu, swhitney@journyx.com
Subject: Re: Re: [ADMIN] Parâmetros para melhor performance do servidor
In-Reply-To: <52266.192.168.207.54.1426624666.squirrel@webmail.etecsa.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox