Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2700764FC5F for ; Sat, 13 Dec 2008 09:23:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96728-03 for ; Sat, 13 Dec 2008 09:22:57 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f14.google.com (mail-bw0-f14.google.com [209.85.218.14]) by mail.postgresql.org (Postfix) with ESMTP id 9A26564FC3C for ; Sat, 13 Dec 2008 09:22:56 -0400 (AST) Received: by bwz7 with SMTP id 7so4362191bwz.19 for ; Sat, 13 Dec 2008 05:22:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=9KEt9WV1SCDF/BD1C9dqNqdYfm2G9IvYO9PX7BEVbDw=; b=oB5BRuWQlcR0p57+GDpYPEN56Gd0CbYXV0P2buyO+oYNIvcE3y/6u97R+/0oLRYQnH CTTkPZKPs3tJ+vXogsf6SeZ/r7kCOBgm62hVGUAr9UuyCMz2i34zczM2qpOm21qLwxny rLjOp4k79FCFJafua4z3H4Zfw/FQa9DSY+ZFE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=jH1QM9s1NX0yDJLlz+Sn87VqGtFiaZZUH9yJ2uYVN3e5XJfB+sztISdoPC5FCkE8k3 U0uIv3HCyb+Cu8HdLvlROiAzfwsdf2X8cx0e7FksdXUG1bniVznK9D2/nzcosq398FrN HfO/DMU/U+FztDdN/akmR7VgSLqMqoVmvsSZM= Received: by 10.223.109.84 with SMTP id i20mr5180496fap.42.1229174574614; Sat, 13 Dec 2008 05:22:54 -0800 (PST) Received: by 10.223.106.209 with HTTP; Sat, 13 Dec 2008 05:22:54 -0800 (PST) Message-ID: <603c8f070812130522l7ccfe9ccx6118c4171f4187d5@mail.gmail.com> Date: Sat, 13 Dec 2008 08:22:54 -0500 From: "Robert Haas" To: jd@commandprompt.com Subject: Re: Need help with 8.4 Performance Testing Cc: "Scott Marlowe" , "Scott Carey" , "Jean-David Beyer" , "pgsql-performance@postgresql.org" In-Reply-To: <1228846285.13962.42.camel@jd-laptop.pragmaticzealot.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1228846285.13962.42.camel@jd-laptop.pragmaticzealot.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/142 X-Sequence-Number: 32178 On Tue, Dec 9, 2008 at 1:11 PM, Joshua D. Drake wrote: >> Those intel SSDs sound compelling. I've been waiting for SSDs to get >> competitive price and performance wise for a while, and when the >> intels came out and I read the first benchmarks I immediately began >> scheming. Sadly, that was right after we're ordered our new 16 drive >> servers, and I didn't have time to try something new and hope it would >> work. Now that the servers are up and running, we'll probably look at >> adding the SSDs next summer before our high load period begins. > > The idea of SSDs is interesting. However I think I will wait for all the > other early adopters to figure out the problems before I start > suggesting them to clients. > > Hard drives work, their cheap and fast. I can get 25 spindles, 15k in a > 3U with controller and battery backed cache for <$10k. This may be a little off-topic, but I'd be interested in hearing more details about how you (or others) would do this... manufacturer, model, configuration? How many hard drives do you need to get 25 spindles? And where can you get that many 15K hard drives for under $10K? My lack of experience in this area is showing here, but, seriously, any suggestions appreciated. ...Robert