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 8749B329E32 for ; Fri, 24 Sep 2004 01:04:43 +0100 (BST) 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 30919-08 for ; Fri, 24 Sep 2004 00:04:37 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 23D6E329CDD for ; Fri, 24 Sep 2004 01:04:38 +0100 (BST) Received: by davinci.ethosmedia.com (CommuniGate Pro PIPE 4.1.8) with PIPE id 6399643; Thu, 23 Sep 2004 17:06:00 -0700 Received: from [66.167.72.154] (account josh@agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.1.8) with HTTP id 6399646; Thu, 23 Sep 2004 17:05:58 -0700 From: "Josh Berkus" Subject: Re: Caching of Queries To: "Jason Coene" , Cc: , , X-Mailer: CommuniGate Pro WebUser Interface v.4.1.8 Date: Thu, 23 Sep 2004 17:05:58 -0700 Message-ID: In-Reply-To: <200409231907.i8NJ7rv2004899@ms-smtp-03.nyroc.rr.com> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/262 X-Sequence-Number: 8390 Jason, > Sorry, I meant 30,000 with 300 connections - not 3,000. The 300 > connections > / second is realistic, if not underestimated. As is the nature of > our site > (realtime information about online gaming), there's a huge fan base > and as a > big upset happens, we'll do 50,000 page views in a span of 3-5 > minutes. First, your posts show no evidences of the CS storm bug. Second, 300 *new* connections a second is a lot. Each new connection requires a significant amount of both database and OS overhead. This is why all the other web developers use a connection pool. In fact, I wouldn't be surprised if your lockups are on the OS level, even; I don't recall that you cited what OS you're using, but I can imagine locking up Linux 2.4 trying to spawn 300 new processes a second. --Josh