2014= -10-06 11:54 GMT-03:00 Emi Lu <emilu@encs.concordia.ca>:

=20 =20 =20
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.
=C2=A0select current_query from pg_stat_activity=C2=A0 where usename =3D'test';
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 current_query=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
--------------------------------------------------------------------------<= br> =C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>
=C2=A0<IDLE>

Thanks a lot!
Emi

Hi Emi,

As far as I know,= it wont affect your performance.

It will affect the overall quantity of users th= at can connect to the database though (since there is a limit that you can = set up on postgres.conf).

BR,

Felipe

--047d7b471e0e52255c0504c2717b-- From jaime.soler@gmail.com Mon Oct 6 21:10:48 2014 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) 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 ) 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 ) 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 ) 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 ; 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 (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: issue? From: jaime soler Reply-To: jaime.soler@gmail.com To: emilu@encs.concordia.ca Cc: "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: 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 El lun, 06-10-2014 a las 10:54 -0400, Emi Lu escribió: > Hello List, > > May I know will 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 > -------------------------------------------------------------------------- > > > > > > > > > > > > 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