X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 51B8BD1B4F6 for ; Mon, 6 Oct 2003 16:36:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 94806-09 for ; Mon, 6 Oct 2003 13:35:31 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id DC81DD1B564 for ; Mon, 6 Oct 2003 13:35:29 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3732345; Mon, 06 Oct 2003 09:35:41 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Jason Hihn , pgsql-performance@postgresql.org Subject: Re: Shopping for hardware Date: Mon, 6 Oct 2003 09:33:27 -0700 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200310060933.27715.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/180 X-Sequence-Number: 3928 Jason, > In terms of numbers, we expect have an average of 100 active connections > (most of which are idle 9/10ths of the time), with about 85% reading > traffic. I hope to have one server host about 1000-2000 active databases, > with the largest being about 60 meg (no blobs). Inactive databases will > only be for reading (archival) purposes, and will seldom be accessed. (I > could probably move them off to another server with a r/o disk...) Hey, two people (one of them me) suggested that rather than putting all 2000 databases on one $15,000 server, that you buy 3 $5000 servers and split things up. You may have considered this suggestion and rejected it, but I'mm wondering if you missed it ... If you're lumping everything on one server, you'll need to remember to increase max_fsm_relations to the total number of tables in all databases ... for example, for 10 tables in 2000 databases you'll want a setting of 20000 (which sounds huge but it's really only about 1mb memory). -- Josh Berkus Aglio Database Solutions San Francisco