X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A22F952D63 for ; Fri, 15 Jul 2005 04:01:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61410-05 for ; Fri, 15 Jul 2005 07:01:43 +0000 (GMT) Received: from veggie-fuel.com (veggie-fuel.com [200.46.208.238]) by svr1.postgresql.org (Postfix) with ESMTP id CA1DD52D60 for ; Fri, 15 Jul 2005 04:01:43 -0300 (ADT) Received: from localhost (unknown [200.46.204.144]) by veggie-fuel.com (Postfix) with ESMTP id 4B8FA35F952 for ; Fri, 15 Jul 2005 07:01:44 +0000 (GMT) Received: from veggie-fuel.com ([200.46.208.238]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62470-04 for ; Fri, 15 Jul 2005 07:01:37 +0000 (GMT) Received: from [10.0.0.7] (63-229-107-222.phnx.qwest.net [63.229.107.222]) by veggie-fuel.com (Postfix) with ESMTP id 238E535F94E for ; Fri, 15 Jul 2005 07:01:37 +0000 (GMT) Subject: What's a lot of connections? From: Karim Nassar Reply-To: karim.nassar@acm.org To: pgsql-performance@postgresql.org Content-Type: text/plain Date: Fri, 15 Jul 2005 00:00:58 -0700 Message-Id: <1121410859.4715.87.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/211 X-Sequence-Number: 13452 I am working on a system that uses postgresql 7.4.2 (can't change that until 8.1 goes stable). Just figured out that there are about 285,000 connections created over about 11 hours every day. That averages out to about 7.2 connections per second. Is that a lot? I've never seen that many. -- Karim Nassar