Message-ID: <51DAF079.1080502@audifarma.com.co>
Date: Mon, 08 Jul 2013 12:01:45 -0500
From: Jeison Bedoya <jeisonb@audifarma.com.co>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:17.0) Gecko/20130620 Thunderbird/17.0.7
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Process in state BIND, authentication, PARSE
References: <51DAE734.3090706@audifarma.com.co>
 <51DAEB63.3050607@dunslane.net>
In-Reply-To: <51DAEB63.3050607@dunslane.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi, yeah i am sorry, i run the postgresql in a machine with this 
configuration

Ram: 128GB
cpu: 32 cores
Disk: 400GB over SAN

The database run an application web over glassfish, and have 2.000 users

my database configuracion is this:

max_connections = 900
shared_buffers = 4096MB
temp_buffers = 128MB
work_mem = 1024MB
maintenance_work_mem = 1024MB
wal_buffers = 256
checkpoint_segments = 103
effective_cache_size = 4096MB

thanks

Atentamente,


JEISON BEDOYA DELGADO
Adm. Servidores y Comunicaciones
AUDIFARMA S.A.

El 08/07/2013 11:40 a.m., Andrew Dunstan escribió:
>
> On 07/08/2013 12:22 PM, Jeison Bedoya wrote:
>> Hi, i want to know why in my database the process stay in BID, PARSE, 
>> autentication, startup by a couple minuts, generating slow in the 
>> process, perhaps tunning parameters? or configuration of operating 
>> system (Linux RHEL 6).
>>
>>
>
>
> You haven't given us nearly enough information about your setup. We'd 
> need to see your configuration settings and have some details of the 
> machine and where connections are coming from to diagnose it further.
>
> cheers
>
> andrew
>
>
>


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