From: Jeison Bedoya <jeisonb@audifarma.com.co>
To: pgsql-performance@postgresql.org
Subject: Re: Process in state BIND, authentication, PARSE
Date: Mon, 08 Jul 2013 12:01:45 -0500
Message-ID: <51DAF079.1080502@audifarma.com.co> (raw)
In-Reply-To: <51DAEB63.3050607@dunslane.net>
References: <51DAE734.3090706@audifarma.com.co>
<51DAEB63.3050607@dunslane.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
>
>
>
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: jeisonb@audifarma.com.co
Subject: Re: Process in state BIND, authentication, PARSE
In-Reply-To: <51DAF079.1080502@audifarma.com.co>
* 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