X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7AF599FB24D for ; Thu, 3 Aug 2006 16:19:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 33092-01 for ; Thu, 3 Aug 2006 19:19:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 8A6689FB205 for ; Thu, 3 Aug 2006 16:19:00 -0300 (ADT) Received: from [2001:700:300:dc0f:216:3eff:fe40:5a47] (helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1G8iif-0005VM-4K for pgsql-performance@postgresql.org; Thu, 03 Aug 2006 21:18:58 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1G8ifC-0005xS-00 for ; Thu, 03 Aug 2006 21:15:22 +0200 Date: Thu, 3 Aug 2006 21:15:22 +0200 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: Message-ID: <20060803191522.GA22878@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: X-Operating-System: Linux 2.6.16trofastxen on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.12-2006-07-14 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/44 X-Sequence-Number: 20229 On Thu, Aug 03, 2006 at 01:33:35PM -0500, Jim Nasby wrote: > I'm at a client who's an ASP; they've written their app such that each > customer gets their own database. Rigth now they're at nearly 200 > databases, and were thinking that they "must be the largest PostgreSQL > install in the world". :) After taking them down a notch or two, I > started wondering how many sites could beat 200 databases in a single > cluster. I'm sure there's any number that can, though 200 databases in a > cluster certainly isn't mainstream. cassarossa:~> psql -h sql -l | grep 'rows)' (137 rows) That's our measly student society. :-) /* Steinar */ -- Homepage: http://www.sesse.net/