Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwEUU-0003Nm-3v for pgsql-performance@arkaria.postgresql.org; Mon, 08 Jul 2013 16:40:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UwEUS-0006kX-Rq for pgsql-performance@arkaria.postgresql.org; Mon, 08 Jul 2013 16:40:40 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwEUR-0006kR-Ux for pgsql-performance@postgresql.org; Mon, 08 Jul 2013 16:40:40 +0000 Received: from relay5-d.mail.gandi.net ([217.70.183.197]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UwEUO-0000Rt-VW for pgsql-performance@postgresql.org; Mon, 08 Jul 2013 16:40:38 +0000 Received: from mfilter18-d.gandi.net (mfilter18-d.gandi.net [217.70.178.146]) by relay5-d.mail.gandi.net (Postfix) with ESMTP id B73BE41C053; Mon, 8 Jul 2013 18:40:11 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at mfilter18-d.gandi.net Received: from relay5-d.mail.gandi.net ([217.70.183.197]) by mfilter18-d.gandi.net (mfilter18-d.gandi.net [10.0.15.180]) (amavisd-new, port 10024) with ESMTP id P8xBUraHcX7z; Mon, 8 Jul 2013 18:40:10 +0200 (CEST) X-Originating-IP: 98.27.58.255 Received: from [192.168.10.146] (cpe-098-027-058-255.nc.res.rr.com [98.27.58.255]) (Authenticated sender: adsend@dunslane.net) by relay5-d.mail.gandi.net (Postfix) with ESMTPSA id 56FE241C056; Mon, 8 Jul 2013 18:40:05 +0200 (CEST) Message-ID: <51DAEB63.3050607@dunslane.net> Date: Mon, 08 Jul 2013 12:40:03 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130110 Thunderbird/17.0.2 MIME-Version: 1.0 To: Jeison Bedoya CC: "pgsql-performance@postgresql.org" Subject: Re: Process in state BIND, authentication, PARSE References: <51DAE734.3090706@audifarma.com.co> In-Reply-To: <51DAE734.3090706@audifarma.com.co> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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