Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DD7349FB5DB for ; Fri, 9 Mar 2007 15:28:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 34184-07 for ; Fri, 9 Mar 2007 15:28:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 08DD59FB5BF for ; Fri, 9 Mar 2007 15:28:34 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Fri, 9 Mar 2007 19:28:34 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 09 Mar 2007 13:28:34 -0600 Subject: Re: configuring new server / many slow disks? From: Scott Marlowe To: Axel Rau Cc: Richard Huxton , pgsql-performance@postgresql.org, Abhijit Menon-Sen In-Reply-To: <834DBEC9-864E-49B0-BE65-E5A6F0378EA3@Chaos1.DE> References: <45F1482F.8030901@archonet.com> <834DBEC9-864E-49B0-BE65-E5A6F0378EA3@Chaos1.DE> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1173468513.20651.298.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 09 Mar 2007 13:28:34 -0600 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/206 X-Sequence-Number: 23611 On Fri, 2007-03-09 at 11:39, Axel Rau wrote: > Am 09.03.2007 um 12:42 schrieb Richard Huxton: > > > Axel Rau wrote: > >> Hi performers, > >> after following this list for a while, I try to configure a > >> database server with a limited budget. > >> Planned are 2 databases > >> - archiveopteryx - http://www.archiveopteryx.org/sql-schema.html > >> - ERDB - https://www.chaos1.de/svn-public/repos/network-tools/ERDB/ > >> trunk/database/ERD.pdf In peak times I expect something like > >> - 50 inserts > >> - 20 updates > >> - 200 selects > >> per second. > > > > Presumably with multiple clients, not just one extremely busy one? > Multiple clients do mainly selects (the IMAP users), few mailservers > are busy and do mainly inserts and updates. > > How big do you expect the databases to get? > Up to 1 TB. The 1st DB is an IMAP message store, which keeps Mime > message parts as byteas in one table (bodyparts). I'd benchmark it to make sure. 20 updates and 50 inserts per second on simple tables with small amounts of data? No problem. Lots of big bytea / blob data getting inserted and read back out? Not so sure. Certainly your BBU RAID controller will help, and lots of slower hard drives is generally far better than a few faster drives. The only way to know is to make up a test and see how it performs.