Re: Process in state BIND, authentication, PARSE - Mailing list pgsql-performance

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
>
>
>