Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52290=pgsql-performance-ar@postgresql.org>)
 id 1XbFYO-0005Jv-Kf
 for pgsql-performance@arkaria.postgresql.org; Mon, 06 Oct 2014 21:10:48 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52290=pgsql-performance-ar@postgresql.org>)
 id 1XbFYN-0000Rs-Hb
 for pgsql-performance@arkaria.postgresql.org; Mon, 06 Oct 2014 21:10:47 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <jaime.soler@gmail.com>)
 id 1XbFYM-0000Re-Cd
 for pgsql-performance@postgresql.org; Mon, 06 Oct 2014 21:10:46 +0000
Received: from mail-wg0-x234.google.com ([2a00:1450:400c:c00::234])
 by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <jaime.soler@gmail.com>)
 id 1XbFYI-0003gS-Qn
 for pgsql-performance@postgresql.org; Mon, 06 Oct 2014 21:10:45 +0000
Received: by mail-wg0-f52.google.com with SMTP id a1so7612725wgh.11
 for <pgsql-performance@postgresql.org>; Mon, 06 Oct 2014 14:10:40 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:subject:from:reply-to:to:cc:date:in-reply-to:references
 :content-type:mime-version:content-transfer-encoding;
 bh=h7JIJqB+VV2Tg5l/45g87ZpJVUIQzguzpzVqOSFU2Vc=;
 b=reW6+MdWlcp5qsrzJ1AyrLyxzqbZ40bgGvRTZ0s+qO84q45VFy8lZzLOkek7Jpvhz1
 tz3z7F0j1eDS2VwPGjIsRTih2x7vQy3iKOvK55NGVEAcCVK5HcvruYzAIXMCW/pUXJbD
 7y9727NrJj67aDo22ct72q8I6KzGY0UxmaDdN/HZhBwnivqjGnc0O0eYH8uBmTr6+z6w
 usDeYVH/xXWkPR2OduGfEKZxzII1YLJ3/l9dBZcf7YmV3KQhSU8bWOcw9GfPgCPtrCHC
 n7rL0JQSW3RZefz/Vo5SjojbBvqilfQOiuwwVdXIWuySBgwFAonqaRS4f5ign72/Pb6e
 2n/g==
X-Received: by 10.180.79.41 with SMTP id g9mr21078622wix.75.1412629840490;
 Mon, 06 Oct 2014 14:10:40 -0700 (PDT)
Received: from [192.168.1.15] (84.125.145.40.dyn.user.ono.com.
 [84.125.145.40])
 by mx.google.com with ESMTPSA id ew1sm18471772wjb.31.2014.10.06.14.10.39
 for <multiple recipients>
 (version=SSLv3 cipher=RC4-SHA bits=128/128);
 Mon, 06 Oct 2014 14:10:39 -0700 (PDT)
Message-ID: <1412629838.3456.9.camel@enterprisedb01>
Subject: Re: <idle> issue?
From: jaime soler <jaime.soler@gmail.com>
Reply-To: jaime.soler@gmail.com
To: emilu@encs.concordia.ca
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: Mon, 06 Oct 2014 23:10:38 +0200
In-Reply-To: <5432AD1E.4070201@encs.concordia.ca>
References: <5432AD1E.4070201@encs.concordia.ca>
Content-Type: text/plain; charset="UTF-8"
X-Mailer: Evolution 3.10.4-0ubuntu2 
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

El lun, 06-10-2014 a las 10:54 -0400, Emi Lu escribió:
> Hello List, 
> 
> May I know will <idle> cause any potential performance issues for
> psql8.3 please?
> version (PostgreSQL 8.3.18 on x86_64-unknown-linux-gnu, compiled by
> GCC 4.1.2)
> 
> E.g., got 10 idle connections for 10 days. 
>  select current_query from pg_stat_activity  where usename ='test';
> 
> current_query                               
> --------------------------------------------------------------------------
>  <IDLE>
>  <IDLE>
>  <IDLE>
>  <IDLE>
>  <IDLE>
>  <IDLE>
>  <IDLE>
>  <IDLE>
>  <IDLE>
>  <IDLE>
> 
> Thanks a lot!
> Emi 

Maybe your application is using a pool of 10 connections but it doesn't
affect any potential performance issues.




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